Entity Framework Core

How EF Core maps your C# objects to database operations — from change tracking and LINQ translation to migrations and performance optimization.

DbContext

Change Tracker

Query Pipeline

IQueryable

SQL Gen

Migrations

Snapshot

Loading

Relationships

Performance

Concurrency

Raw SQL

Core

Unit of Work pattern, entity states (Added/Modified/Deleted), and SaveChanges flow.

How migration snapshots track database changes and generate SQL diff scripts.

Query Engine

IQueryable → expression tree → SQL generation — how EF translates your LINQ.

Compiled queries, split queries, global query filters, and avoiding N+1.

FromSqlRaw, ExecuteSqlRaw — when and how to escape the ORM.

Schema & Data

Eager vs Lazy vs Explicit loading — trade-offs and the N+1 problem.

FK conventions, shadow properties, cascade delete, and owned types.

Optimistic concurrency with row versioning and conflict detection.