>>First of all add database connection string in appsetting.json:
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"ConnectionStrings": {
"dbcs": "Server=.;Database=StudentsDB;Integrated Security=True ;TrustServerCertificate=True;"
},
"AllowedHosts": "*"
}
>>Add these line after builder declaration/intilization:
var provider = builder.Services.BuildServiceProvider();
var config = provider.GetRequiredService<IConfiguration>();
builder.Services.AddDbContext<StudentsDbContext>(item => item.UseSqlServer(config.GetConnectionString("dbcs")));