How do you configure a DbContext in .NET Core?

Question

Utpal Vishwas · Answer

In ASP.NET Core, you configure a DbContext by:
Creating a class that inherits from DbContextRegistering it in the Program.cs (or
Startup.cs for older versions)Specifying a connection string and provider (e.g., SQL Server)
Step-by-Step: Configuring a DbContext
1. Create a Model
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
}
2. Create the DbContext
using Microsoft.EntityFrameworkCore;
public class AppDbContext : DbContext
{
    public AppDbContext(DbContextOptionsandlt;AppDbContextandgt; options)
        : base(options) { }
    public DbSetandlt;Productandgt; Products { get; set; }
}
3. Add Connection String in appsettings.json
{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=MyDb;Trusted_Connection=True;"
  }
}
4. Register DbContext in Program.cs (.NET 6/7/8)
var builder = WebApplication.CreateBuilder(args);
// Register DbContext with SQL Server
builder.Services.AddDbContextandlt;AppDbContextandgt;(options =andgt;
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));
var app = builder.Build();
// ... app.UseRouting(), app.MapControllers(), etc.
app.Run();
For other databases:
Use .UseSqlite(), .UseNpgsql(), .UseMySql(), etc.
Done! You can now inject AppDbContext anywhere:
public class ProductService
{
    private readonly AppDbContext _context;
    public ProductService(AppDbContext context)
    {
        _context = context;
    }
    public Listandlt;Productandgt; GetAll() =andgt; _context.Products.ToList();
}
Summary
Task
How to do it
Define the context
Inherit from DbContext
Register in DI
builder.Services.AddDbContext
Set the connection string
In appsettings.json
Use in app
Inject via constructor
and

interview

How do you configure a DbContext in .NET Core?

Utpal Vishwas

Can you answer this question?

1 Answers

Step-by-Step: Configuring a `DbContext`

1. Create a Model

2. Create the DbContext

3. Add Connection String in `appsettings.json`

4. Register DbContext in `Program.cs` (.NET 6/7/8)

Done! You can now inject `AppDbContext` anywhere:

Summary

Liked By

Task	How to do it
Define the context	Inherit from `DbContext`
Register in DI	`builder.Services.AddDbContext`
Set the connection string	In `appsettings.json`
Use in app	Inject via constructor