Entity Framework Core - Inspecting Generated DB Query

Translating C# LINQ expressions into database-specific SQL is the core responsibility of EF Core. However, because this translation is abstract, it can sometimes lead to inefficient queries (e.g., N+1 problems, Cartesian explosions, or index scans). ...