Skip to main content
ANVISoftware Solutions

Module 04 of 04 · Entity Framework Core

Performance and Escape Hatches

Find out what SQL is actually running, fix the common traps, and know when to write SQL yourself.

4 of 4 lessons available

Lessons in this module

  1. 01

    The N+1 Query Problem

    Advanced

    Recognise, reproduce and fix the most common EF Core performance bug.

    20 min
  2. 02

    Indexes

    Advanced

    Add indexes that support your real queries.

    16 min
  3. 03

    Raw SQL and Stored Procedures

    Advanced

    Drop to SQL when the ORM is the wrong tool, without losing safety.

    16 min
  4. 04

    Query Optimisation

    Advanced

    Diagnose a slow query from the generated SQL and its plan.

    18 min

Have a project worth talking through?

Tell us what you're building or what's slowing your current system down. We'll give you a direct read on scope and approach.

Start a ConversationExplore Our Services