c# - 我如何从孙子那里获取数据？

Question

我有 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

Answer 1

您可以尝试如下所示。

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