Loading grand children in a entity Framework

Question

I've a Following hierarchy of entitites

 class ClassA { ICollection<ClassB> classBs { get; set; } } class ClassB { ClassC classC { get; set; } ClassD classD { get; set; } } class ClassC { } class ClassD { }

I want that when I load an instance of classA, then all the related instance of classB and their related instances of ClassC and classD should get populated. The code written in my repositories is something like:

 context.ClassAs.Include(c => c.classBs)

This returns all the related instances of classBs, but the classB has classC and ClassD, which doesn't get populated. I looked at some resources online, but it didn't show how to eager load this simple kind of hierarchy. Any help would be really appreciated.

George Johnston · Accepted Answer · 2013-04-17 16:22:42Z

One solution would be to use Select to include only children of children you want loaded, e.g.

context.ClassAs .Include(c => c.classBs.Select(c=>c.ClassC)) .Include(c => c.classBs.Select(d=>d.ClassD))

Collectives™ on Stack Overflow

Loading grand children in a entity Framework

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related