миграция на ef
PM> add-migration MyFirstMigration
PM> Update-Database
как asp.net ядрото работи с sql server
public void ConfigureServices(IServiceCollection services)
{
services.AddRazorPages();
services.AddDbContext<RazorPagesMovieContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("RazorPagesMovieContext")));
}