[azibi]

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

[exceptione]

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.

[sbergot]

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

[queuep]

For sure it is

[exceptione]

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