EF Core Split Query vs Single Query for Include
Including two or more collections in one EF Core query multiplies result rows through JOINs. AsSplitQuery fixes that with extra round trips — here's when each mode wins and how to verify with logged SQL.