Why should you care?

ShopNest needs SQL Server to save products and orders. EF Core is how C# objects become database tables.

See it live — copy this example

Create an MVC project (dotnet new mvc), add the code, and run dotnet run.

// appsettings.json
"ConnectionStrings": {
  "DefaultConnection": "Server=(localdb)\mssqllocaldb;Database=ShopNest;Trusted_Connection=True;"
}

// Program.cs
builder.Services.AddDbContext<ShopNestDbContext>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

Run Example »

Edit the code and click Run — like W3Schools Try it Yourself.

What happened?

• DbContext is the gateway to the database.
• AddDbContext registers it per HTTP request (scoped).
• Connection string points at SQL Server or LocalDB.

Try it yourself

1. dotnet add package Microsoft.EntityFrameworkCore.SqlServer
2. Create ShopNestDbContext : DbContext with DbSet.
3. Add connection string and register in Program.cs.
4. Change text or labels in the example and run again — watch the browser update.
5. Break the code on purpose (remove a semicolon), read the error message, then fix it.

Remember

EF Core + SQL Server + DbContext + connection string. Register in Program.cs. Migrations create tables.