Lazy loading with EF 5 Database first

Question

I have three tables in my database:

Post
Author
Tags

I'm using ASP.NET MVC 4 with EF 5 and my Post model (generated automatically) looks like this one:

public partial class BlogPost
{
    public BlogPost()
    {
        this.Tags = new HashSet<Tag>();
    }

    ...

    public virtual Author Author { get; set; }
    public virtual ICollection<Tag> Tags { get; set; }
}

My context and dbSet are definded. I'm trying to get all the posts in the database with this query

dbSet.ToList()

I thought that Author will be null and Tags will be empty, because I didn't use Include() to use eager loading. But if I debug, I found that Author isn't null and Tags got two elements. I don't understand why.

In Tag entity I got a navigation property to get all the posts that got that Tag. It looks like is filling all the data... but I don't notice any performance problem when I test the page, it load very fast.

Maybe it's not an error... am I just missing something?

Community · Accepted Answer · 2017-05-23 11:56:35Z

4

Please check this answer:

Lazy Loading means that entities will be automatically loaded when you first access collection or navigation property, and that will happen transparently, as though they were always loaded with parent object.

Using "include" is loading on demand, when you specify properties you want to query.

Hope this helps.

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Sep 25, 2013 at 21:27

Manikandan Sigamani

1,9941 gold badge15 silver badges28 bronze badges

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

1 Comment

Gabbyboy Over a year ago

Thank you, I knew that I was missing something. :)

Collectives™ on Stack Overflow

Lazy loading with EF 5 Database first

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related