[lIIllIIllIIllII]

Not really true. You can have separate queries to avoid cartesian explosions. EF Core implements it and its standard practice to use - but not enabled by default, because if you don't order by something unique you'll have a bad time.

https://learn.microsoft.com/en-us/ef/core/querying/single-sp...