Avoiding Cartesian Explosion in EF Core: Use AsSplitQuery for Collection Includes
EF Core’s AsSplitQuery splits collection includes into separate queries, preventing cartesian explosion. This guide explains the mechanism, shows a worked example, and covers limits and common pitfalls.
entityframeworkcore