DbSet in EF Core

DbSet in EF Core — a practical guide to EF Core DbSet with clear examples you can reuse in real projects.

ASP & ASP.NET Tutorial Series (192/247). Prefer one article? Read the complete ASP.NET tutorial.

Short description

Prefer LINQ over raw string SQL when possible.

DbSet tip

var items = await db.Items.Where(i => i.IsActive).ToListAsync();