Search for existing suggestions

Use multiple result sets to handle Include statements

Currently, EF uses a flat query in order to populate navigation property values when using eager loading via the Include statement. While this is acceptable in some (perhaps many) cases, there are a lot of cases where this produces unacceptable queries, whether from a size or performance perspective.

While this performance bottleneck can be partially avoided by using LoadProperty, this is

a) less expressive and more verbose
b) potentially more expensive, as it requires a round-trip for every property on every entity

Instead, please allow us the option of having EF generate multiple SELECT statements to address each navigation property

7 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Adam Robinson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base