Combining lazy and eager loading in EF Core

Question

My project uses Entity Framework Core as ORM. Lazy loading is enabled by default:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    optionsBuilder.UseLazyLoadingProxies();
}

I need to write a code, which processes some big collection of objects with navigation properties. To decrease amount of database requests, I would like to download the objects with their navigation properties "eagerly".

What is right way to do this? Can I just use something like this:

dbContext.MyObjects.Include(myObject => myObject.NavigationProperty).ToListAsync()

Yes. This is the case when better to try first.

Svyatoslav Danyliv
– Svyatoslav Danyliv

2021-09-24 15:24:54 +00:00
Commented Sep 24, 2021 at 15:24 — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Sep 24, 2021 at 15:24

Vočko · Accepted Answer · 2021-09-28 04:26:15Z

1

Yes, Include forces the EF to load the data for the given property within the query.

You might also consider to use .ToListAsync() overload and await the call. It might help the thread to not freeze while loading a huge result set from the database.

Doco with examples can be found here: https://learn.microsoft.com/en-us/ef/core/querying/related-data/eager

answered Sep 28, 2021 at 4:26

Vočko

3,0742 gold badges28 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combining lazy and eager loading in EF Core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related