Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / how do you configure a dbcontext in .net core?
Ask Question
Utpal Vishwas
Utpal Vishwas

Student

I am Utpal Vishwas from Uttar Pradesh. Have completed my B. Tech. course from MNNIT campus Prayagraj in 2022. I have good knowledge of computer networking.

Message

1 Answers

Utpal Vishwas
Utpal Vishwas 20 May 2025
Report Abuse

In ASP.NET Core, you configure a DbContext by:

  1. Creating a class that inherits from DbContext
  2. Registering it in the Program.cs (or Startup.cs for older versions)
  3. 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(DbContextOptions<AppDbContext> options)
        : base(options) { }

    public DbSet<Product> 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.AddDbContext<AppDbContext>(options =>
    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 List<Product> GetAll() => _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
advertising