New Posts New Posts RSS Feed: How to access nested navigation properties
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

How to access nested navigation properties
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
anwar View Drop Down
Newbie
Newbie


Joined: 23-Jul-2009
Posts: 2 		Post Options Post Options   Quote anwar Quote  Post ReplyReply Direct Link To This Post Topic: How to access nested navigation properties
    Posted: 18-Jan-2010 at 11:43am
Hello All,
 
My entity model contains multilevel navigation properties, can any one help  me how to access multilevel/nested  navigation properties.
 
The sample in developer guide shows one level of navigation access. here is the code snippet from dev. guide.
 

// Retrieve a collection of related entities using a collection navigation property

targetOrder.OrderDetails.PendingEntityListResolved +=

new EventHandler<PendingEntityListResolvedEventArgs<OrderDetail>>(

OrderDetails_PendingEntityListResolved);

 

void OrderDetails_PendingEntityListResolved(object sender,

PendingEntityListResolvedEventArgs<OrderDetail> e) {

Console.WriteLine("OrderDetails retrieved: {0}", e.ResolvedEntities.Count);

}

 
Help will be appricitated.
 
Thanks,
Anwar
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 19-Jan-2010 at 3:52pm
Nested navigation properties should end with either a scalar (e.g., Order.Customer.FirstName) or with a list or collection (e.g., Order.Customer.Orders).  If you are using a scalar, use a scalar navigation property (such as one that requires PendingEntity). If you are querying for a collection, use a collection navigation property (such as one that requires PendingEntityList).
Back to Top
GregD View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 374 		Post Options Post Options   Quote GregD Quote  Post ReplyReply Direct Link To This Post Posted: 20-Jan-2010 at 3:56pm
Anwar:

I'm going to expand a bit on David's answer with a couple of examples of accessing multilevel navigation properties, using entities from NorthwindIB:

     anOrder.Customer.Orders

would retrieve all of the Orders (i.e., a collection) for the Customer associated with anOrder.

     anOrderDetail.Product.Supplier

would return the Supplier (i.e., a scalar) associated with the Product mentioned in anOrderDetail.

When operating in an asynchronous environment like Silverlight, you will often want to be notified when retrieval of the referenced entity or entities has completed.  For a collection navigation property like anOrder.Customer.Orders you would handle the PendingEntityListResolved event on the referenced property. For a scalar navigation property like anOrderlDetail.Product.Supplier you would handle the PendingEntityResolved event on the referenced property.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down