Entity Framework Core Tutorial

1. EF Core Introduction

What EF Core is, defining entities and a DbContext, and the code-first approach.

2. Migrations & CRUD

dotnet ef migrations add/database update, and a complete CRUD example against a DbSet.

3. LINQ Queries & Relationships

Composing Where/OrderBy/Select against a DbSet, and eager loading relationships with Include.

4. Performance & Query Optimization

AsNoTracking() for read-only queries, avoiding N+1 with Include, AsSplitQuery, and compiled queries.

5. Handling Concurrency Conflicts

Optimistic concurrency with a [Timestamp]/rowversion column and catching DbUpdateConcurrencyException.

6. EF Core Interview Questions

Commonly asked EF Core interview questions with clear, practical answers.