Performance Optimization

Entity Framework Core makes data access look like in-memory LINQ, which is why it's easy to write slow code with it. The translation from LINQ to SQL is mechanical, but the choices made in C# (which navigation to include, whether to track entities, when to call .ToList()) decide whether one request fires one query or two hundred. This lesson covers how to see what EF is actually doing, the patterns that turn into performance problems, and the tools EF Core 8 provides to fix them.