title: How do I get data from grandchildren?
body: <p>I have EF 3.5 and I am trying to get information from 3 different entities.<br>
  <code>orders</code> has a navigation to <code>orderitems</code> and <code>orderitems</code> has a navigation to <code>ProductSize</code> which has navigation to <code>Product</code>.  Problem arises when I use <code>.Include</code> statement to add the additional entities to <code>Orders</code> the return only shows data from <code>Orders</code> and not from any of the others.</p>
  
  <p>Here is sample</p>
  
  <pre><code>var query = (from c in context.Orders
  .Include("OrderItems")
  .Include("OrderItems.ProductSize:)
  .Include("OrderItems.ProductSize.Product)
  
  select c).ToList()
  
  Order
  
  OrderID
  Comments
  EDIPI
  IssuedDate
  OrderItems Navigation
  ShippingLocation Navigation
  
  OrderItem
  
  OrderItemID
  Quantity
  Issued
  Order Navigation
  ProductSize Navigation
  
  ProductSize
  
  ProductSizeID
  Size
  NSN
  Price
  Items Navigation
  Product Navigation
  OrderItems Navigation
  </code></pre>