Hi

I've a self-referencing table mapping onto an entity with relations called Parent(m:1) and Children(1:n).

I want to load the entire hierarchy up and then recurse through adding it to a treeview.

I've loaded the entire entity collection (using linq and then calling ToList()) and although the ParentID property is correct on the appropriate entities, the actual Parent property returns null?

Is there something special I have to do to get the Parent property returning the actual Parent entity?

Thanks Garrett

Hi Garret,

When using LINQ2LLBL you need to use prefetchPaths this way.

Please let us know whether that's what you are looking for, and whether you need further help on this. If you need such help, post the code snippet you have so far

Thanks but I got the prefetch paths for some other entities - my question is why, when i load an entire table hierarchy the parent and children properties are not populated?

Could you please post your code snippet and what are the not-populated children?