ASP.NET Core - Work with a database

Required nuget

  1. Microsoft.EntityFrameworkCore
  2. Microsoft.EntityFrameworkCore.SqlServer


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"))));