Linq To Sql Entity Framework Getting Nested Entities

Question

I'm trying to do an include of a nested entity. I assumed the below code would work but it does not recognize the CapitalMailOrders entitycollection. Can anyone point me in the right direction to include these?

    var result = db.Contacts
        .Include(a => a.IDXPageLinks)
        .Include(b => b.ReboGatewayLoginInfoes)
        .Include(c => c.SocialMedias)
        .Include(d => d.WebSiteInfoes)
        .Include(e => e.ContactImages)
        .Include(f => f.RealtorSetUpProcesses)
        .Include(h => h.RealtorSetUpProcesses.CapitalMailOrders) // getting compile time error here. Doesn't recognize Entity 
        .Include(g => g.Contact_CarrierCode_Assignments)
        .FirstOrDefault(c => c.ContactID == id);

Thanks

enter image description here

Phil Wright · Accepted Answer · 2015-03-04 03:59:48Z

1

The extra entity level is accessed from a collection and so you need to add a Select in order to bring all the entries into the include.

.Include(h => h.RealtorSetUpProcesses.Select(h2 => h2.CapitalMailOrders)

edited Mar 4, 2015 at 3:59

answered Mar 4, 2015 at 3:49

Phil Wright

23k16 gold badges88 silver badges142 bronze badges

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

3 Comments

Tim Over a year ago

Get the error "A specific Include path is not valid. The entity type does not declare a navigation property with the name CapitalMailOrders". I tried it with "RealtorSetUpProcesses.CapitalMailOrders" and it didn't throw any errors but it didn't include the nested collection.

Phil Wright Over a year ago

Does your Contacts entity have a navigation property to RealtorSetupProcesses and does the RealtorSetupProcesses have a navigation property to the CapitalMailOrders?

Tim Over a year ago

Thanks @Phil. That worked. I think the main problem was there was no data in the table. After I added record and changed to your updated snippet I was able to look at the collection. Thanks again.

Collectives™ on Stack Overflow

Linq To Sql Entity Framework Getting Nested Entities

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related