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...