Loading Multiple Related Hierarchical Objects

Question

I have below tables

1. Address -> AddressID
2. Designation -> DesignationID
3. Stores -> StoreID, AddressId
4. Contacts -> ContactID, StoreID, DesignationID
5. ContactsAddresses => ContactID, AddressID

and related NavigationProperties. I want to load all the Stores with all Contacts and their contact's associated Data (Designation and ContactsAddresses)

I tried something like below:

this.ObjectContext.Stores.Include("Contacts.Designation.ContactsAddresses")
   .Include("Address");

I have a doubt that when I write Contacts.Designation.ContactsAddresses -> whether it consider ContactsAddresses as Contacts navigation property or Designation's navigation Property. Cause I also need to include Address in ContactsAddresses. Its multiple hierarchy which needs to be resolved.

I want to have each contact's Designation and all addresses. Can anyone please help me solving this issue.

Eranga · Accepted Answer · 2012-02-07 11:20:07Z

2

Explicitly specify the two include paths.

this.ObjectContext.Stores.Include("Contacts.Designation")
     .Include("Contacts.ContactsAddresses");

edited Feb 7, 2012 at 11:20

answered Feb 7, 2012 at 8:13

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

1 Comment

Eranga Over a year ago

@TejasPatel Removed an extra property in second Include method. I tried this and worked.

Collectives™ on Stack Overflow

Loading Multiple Related Hierarchical Objects

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related