c# - 我如何从孙辈那里获得数据？

我有EF 3.5，我正在尝试从3个不同的实体中获取信息。
orders导航至orderitems，orderitems导航至ProductSize，导航至Product。当我使用.Include语句将其他实体添加到Orders时，会出现问题，返回仅显示来自Orders的数据，而不显示来自任何其他实体的数据。

这是样品

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

最佳答案

您可以尝试如下所示。

var query = (from c in context.Orders select c)
            .Include(oi=>oi.OrderItems.Order)
            .Include(o=>o.OrderItems.ProductSize.Product)
            .ToList();