Skip to content
Search lessons, topics, tests…
Esc

    ↑ ↓ moveEnter openEsc close
    Data Access in .NET: all courses in this track

    Guided course · Data Access in .NET

    EF Core Performance and Behavior

    Know what EF Core really does with your queries and writes, and how to make it fast and safe in production: change tracking and AsNoTracking, loading strategies and N+1, split queries, query translation and client evaluation, compiled queries, ExecuteUpdate/ExecuteDelete, optimistic concurrency, transactions and savepoints, DbContext lifetime and pooling, connection resiliency, migrations in production, raw SQL, interceptors and performance diagnostics. 18 lessons with runnable EF Core 10 examples (SQLite and SQL Server), real output, a 12-exercise practice set and a 25-question mock interview.

    Intermediate5 modules · 18 lessons · 5 h 18 min · 2 free
    Start the courseSave

    Module 1 · Foundations

    2 lessons · 34 min
    1. 01How EF Core Runs a Query: Expression Trees, SQL, Logging and ToQueryStringFree16 min
    2. 02Change Tracking: Entity States, Snapshots, DetectChanges and the Identity MapFree18 min

    Module 2 · Reading Data Efficiently

    5 lessons · 1 h 17 min
    1. 03AsNoTracking, Identity Resolution and the Real Cost of Tracking (included with Full Access)15 min
    2. 04Loading Related Data and N+1: Eager, Explicit, Lazy and Projections (included with Full Access)18 min
    3. 05Split Queries and Cartesian Explosion: AsSplitQuery vs Single Query (included with Full Access)14 min
    4. 06Query Translation and Client Evaluation: What EF Can and Cannot Turn into SQL (included with Full Access)16 min
    5. 07Compiled Queries, the Query Cache and Parameterization (included with Full Access)14 min

    Module 3 · Writing Data

    3 lessons · 49 min
    1. 08Bulk Updates and Deletes: ExecuteUpdate, ExecuteDelete and SaveChanges Batching (included with Full Access)16 min
    2. 09Optimistic Concurrency: Rowversion, Concurrency Tokens and Resolving Conflicts (included with Full Access)18 min
    3. 10Transactions in EF Core: SaveChanges Atomicity, Explicit Transactions and Savepoints (included with Full Access)15 min

    Module 4 · Production Concerns

    6 lessons · 1 h 33 min
    1. 11DbContext Lifetime, Thread Safety, Pooling and IDbContextFactory (included with Full Access)16 min
    2. 12Connection Resiliency: EnableRetryOnFailure, Execution Strategies and Uncertain Commits (included with Full Access)15 min
    3. 13Migrations in Production: Idempotent Scripts, Bundles and Why Not Migrate() at Startup (included with Full Access)17 min
    4. 14Raw SQL in EF Core: FromSql, SqlQuery, ExecuteSql and SQL Injection (included with Full Access)14 min
    5. 15Interceptors: Auditing, Soft Delete, Slow-Query Logging and Query Filters (included with Full Access)15 min
    6. 16Performance Diagnostics: Metrics, Logs, Warnings and a Tuning Workflow (included with Full Access)16 min

    Module 5 · Practice and Assessment

    2 lessons · 1 h 5 min
    1. 17Practice Set: 12 "Find the EF Core Problem and Fix It" Exercises (Solved and Measured) (included with Full Access)30 min
    2. 18Final Mock Interview: 25 Questions on EF Core Performance and Behavior (included with Full Access)35 min