Category: ASP.NET

Query and track entities through DbSet.

Evolve schema with migrations and update the database.

Compose queries with LINQ that translate to SQL.

Add/update/remove entities and SaveChangesAsync.

Configure one-to-many and many-to-many with conventions/Fluent API.

Eager load with Include; be careful enabling lazy loading proxies.

Define a DbContext that exposes DbSets and configuration.

Encapsulate SQL in stored procedures when policy requires.

Create views for reusable query shapes and security layering.

Group multi-step writes with transactions for atomicity.