ASP.NET Core - Work with a database
Required nuget
public class DatabaseNameContext : DbContext { public DatabaseNameContext (DbContextOptions<MvcMovieContext> options) : base(options) { } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("DatabaseConnectionString"); } public DbSet<ModelName> Models{ get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); } }
appsettings.json
{ "ConnectionStrings": { "DatabaseNameContext": "DatabaseConnectionString" } }
Program.cs
var builder = WebApplication.CreateBuilder(args); builder.Services.AddDbContext<DatabaseNameContext>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("DatabaseNameContext"))));