Hacker News Reader

There is a name for this problem, Cartesian explosion: https://en.wikipedia.org/wiki/Cartesian_explosion

Correct. However, this imho does not need to be a problem when using references to data instead of data duplication when sending results over the wire.

I hope it is implemented with multiple result sets and a single roundtrip

For sure it is

EF Core documentation disagrees though: https://learn.microsoft.com/en-us/ef/core/querying/single-sp...

Reply on news.ycombinator.com