Entity Framework 7 Core disable auto loading

Asked Feb 22 '17 at 20:06

Active Feb 22 '17 at 20:06

Viewed 722 times

I am not use virtual navigation property

I want manually specify fields to load

IQueryable<ScheduleModel> q = _db.Schedules;
q = q.Include(x => x.ElementItem); <-- load ElementItem
q = q.Include(x => x.ScheduleHours); <-- load collection

But EF7 load (or assign) ScheduleHours[0..x].ElementItem because ElementItem with same Id loaded in first Include()

After serialization in Json I have big model.

How disable auto loading not specified fields?

asked Feb 22 '17 at 20:06

Alexandr Sulimov

1,894
2
24
48

Make your navigation properties `virtual`, they won't be loaded unless you explicitly load them using `Include`. – Bradley Uffner Feb 22 '17 at 20:09
EF Core doesn't support lazy loading yet: http://stackoverflow.com/questions/41881169/navigation-property-should-be-virtual-not-required-in-ef-core – Alexan Feb 22 '17 at 20:09
@BradleyUffner, virtual doesn't work in EF Core – Alexan Feb 22 '17 at 20:10
@Alex It was working for me yesterday, `virtual` properties were not loading unless I called `Include` on them. – Bradley Uffner Feb 22 '17 at 20:11
https://learn.microsoft.com/en-us/aspnet/core/data/ef-mvc/read-related-data#eager-explicit-and-lazy-loading-of-related-data – Alexan Feb 22 '17 at 20:11
2

You confuse lazy loading with relationship fixup. EF will populate navigation properties with entities it has loaded into the context. – Gert Arnold Feb 22 '17 at 20:12
@Alex load not specified fields is LazyLoading? I don`t want load any not specified properties – Alexandr Sulimov Feb 22 '17 at 20:12
@Alex There are way to disable auto populate? – Alexandr Sulimov Feb 22 '17 at 20:13
1

@AlexandrSulimov Read carefully the Gert Arnold's comment. Also the **Tip** in the [Loading Related Data](https://learn.microsoft.com/en-us/ef/core/querying/related-data) section of the EF Core documentation. Shortly, no, you can't disable that behavior because it's "by design". – Ivan Stoev Feb 22 '17 at 20:19
This is about EF5, but as for me, it's a duplicate: http://stackoverflow.com/q/31107876/861716 – Gert Arnold Feb 22 '17 at 20:24
but https://learn.microsoft.com/en-us/aspnet/core/data/ef-mvc/read-related-data#use-multiple-queries – Alexan Feb 22 '17 at 21:51
1

q = q.AsNoTracking(); - was solve problem – Alexandr Sulimov Feb 23 '17 at 07:30

Entity Framework 7 Core disable auto loading

0 Answers0

Linked