EF Core 11 optimizes split queries by removing unnecessary joins and order-by clauses from child entity queries when reference navigations are included. Previously, every collection query redundantly joined all reference navigation tables, causing performance degradation as the number of includes increased. This update significantly reduces database workload and improves query execution speed for complex entity graphs.
Background
Entity Framework Core is a popular Object-Relational Mapping (ORM) framework for .NET applications, widely used for database interactions. Split queries are a technique used to avoid the Cartesian explosion problem when loading entities with multiple collections.
- Source
- Lobsters
- Published
- Jul 12, 2026 at 10:02 PM
- Score
- 7.0 / 10