Blog121.1K views4,297 votes0 replies2,236 following
When EF Core's Include Quietly Explodes Your Query: Reaching for AsSplitQuery
Eager-loading two or more collections with Include can multiply result rows into a cartesian explosion. Here's how AsSplitQuery fixes it, with a worked example and the trade-offs to weigh.
entityframeworkcoreassplitqueryentity-framework-coreTasadduq Burneyowner30.8K rep · 05 Jul 2025, 02:00 UTC