Do you know how does it work under the hood? I mean, in your example you pass query like select * from... but, since it's lazy loaded, what's the actual query executed?
How I see it is it retrieves records one by one, which is something similar to looping through IQueryable.
Am I wrong? If so, how does it work exactly?
select * from...
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.