Entity Framework lazy loading

Question

using(DataContext db = new DataContext ())
{
    var result = db.SomeTable.ToList();
    return result;
}

Problem is after i have returned the result, the connection is closed and because its closed, it crashes when i am trying to access any of the child elements. That happens because with lazy loading set to True ( default ) it never loads the child relations before they are used and i start using them AFTER the connection is closed. So how is the best way to solve this?

I have tried to turn off the lazy loading but then it didnt load any of the child relation tables.

Justin Niessner · Accepted Answer · 2011-01-10 14:42:24Z

14

You can always explicitly load your child collections:

var result = db.SomeTable.Include("SomeChildCollectionName")
                         .Include("AnotherChildCollectionName")
                         .ToList();

answered Jan 10, 2011 at 14:42

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

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

2 Comments

syncis Over a year ago

Ok but what if i want to load ALL child elements without having to explicitly writing include("ElementName") ? There is a lot of child elements , thats why

Justin Niessner Over a year ago

@user554978 - That isn't supported. You have to explicitly load all the children up front using Include or keep the connection open and allow Lazy Loading to do its thing.

DCNYAM · Accepted Answer · 2011-01-10 14:41:45Z

3

You can use the .include() method.

var result = db.SomeTable.Include("ChildEntitySet").ToList();

You can also add a result.ChildEntitySet.Load() call before returning. This is less efficient as it will result in two trips to the server. Using the .Include() method will generate a SQL Statement with a JOIN allowing only one trip to the server.

answered Jan 10, 2011 at 14:41

DCNYAM

12.2k8 gold badges57 silver badges71 bronze badges

1 Comment

syncis Over a year ago

Ok but what if i want to load ALL child elements without having to explicitly writing include("ElementName") ? There is a lot of child elements , thats why

Collectives™ on Stack Overflow

Entity Framework lazy loading

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related