Entity Framework 6 lazy loading issue

Question

I have this entity:

public class Crash : BaseModel { public string Message { get; set; } public DateTime Time { get; set; } public int ApplicationId { get; set; } public virtual Application Application { get; set; } }

The following works perfect and navigation property Application is correct:

_context.Set<T>().ToList();

But this one those not fill the Application:

_context.Set<T>().First(expression);

The correct item is retrieved, though In the acquired item property Application is null.

What should I do to find an item with expression and still have auto loading of the navigation properties??

CodingYoshi · Accepted Answer · 2016-11-22 00:13:46Z

You need to load it by including it in your query. This is known as eager loading.

_context.Set<Crash>().Include(x => x.Application).First(expression);

You can also turn off lazy loading and the navigation property will be loaded when you access it. But keep in mind this can cause performance issues. Turning lazy loading off will have a global effect.

If you just want this specific property to be loaded without having an include as I have shown above, you can make the property not virtual.

Here is a link for more information on lazy loading etc.

Ivan Mokrov · Accepted Answer · 2016-11-22 00:03:22Z

First() returns only ONE single value, not a collection. Unlike ToList() do.

Your control wait for collection to come.

Single value is not a collection with only single value;

You need to create a collection with one record of your First() returned value. That will be a List of one record.

Collectives™ on Stack Overflow

Entity Framework 6 lazy loading issue

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related