Performance Optimization

Entity Framework Core makes data access feel like in-memory LINQ, and that's exactly why it's easy to write slow code with it. The translation from LINQ to SQL is mechanical, but the choices you make in C# (which navigation you include, whether you track entities, when you 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 gives you to fix them.