DevForce Community Forum : Include child of child http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Include child of child Sun, 12 Apr 2026 08:52:35 -700 Wed, 23 Nov 2011 12:42:08 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3107 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Include child of child : Hi Scott;In this case, we actually... http://www.ideablade.com/forum/forum_posts.asp?TID=3107&PID=12105#12105 Author: DenisK
Subject: 3107
Posted: 23-Nov-2011 at 12:42pm

Hi Scott;

In this case, we actually need to use the non-strongly typed version of Include.

manager.Orders.Include("OrderDetails.Product").Execute();

Please see http://drc.ideablade.com/xwiki/bin/view/Documentation/include-related-entities for more details.

Hope this helps.


]]> Wed, 23 Nov 2011 12:42:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3107&PID=12105#12105 Include child of child : I've got what is probably... http://www.ideablade.com/forum/forum_posts.asp?TID=3107&PID=12104#12104 Author: scottarlp
Subject: 3107
Posted: 23-Nov-2011 at 9:57am

I've got what is probably a silly problem. I want to include the child of a child in my query. The problem appears to be the fact that my grandchild is m:1 and the only syntax I see examples for (and work) are for 1:m. I have the following type of data.
 
Order - Standard type of order example.
Order Detail - 1:m with Order, the line items of an order.
Product - Referenced by Order Detail as m:1 (Order Detail : Product).
 
I've got a query something like the following.
 
var query =
manager.Order
.Include(Order.PathFor(order => order.OrderDetails);
 
This works fine and fetches from the db once as expected. However, I'm trying to display product for the Order Detail in a grid and since it's not included (or in cache at the time), it does a lazy call for every record to retrieve the Product record.
 
In the examples of using 1:m includes, it looks like you can do this:
 
var query =
manager.Order
.Include(Order.PathFor(order => order.OrderDetails)
.Include(Order.PathFor(order => order.OrderDetails.Products);
 
But since that relationship is m:1, you don't get an option for the Products relation. Is there some other way other than just flat querying the Product table to load it in cache (in my real example, it's actually several related tables).
 
Thanks,
Scott
]]> Wed, 23 Nov 2011 09:57:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3107&PID=12104#12104