linq - 是否可以查询 Odata 服务并展开 Child of Child 实体？

Question

这听起来很简单(也许我在这里遗漏了显而易见的东西)但我找不到解决方案。我知道我可以查询一个实体并返回一个或多个执行此操作的直接子实体:

var query = from c in Service.Clients.Expand("Addresses,Comments,PhoneNumbers")..

我希望能够做的是对 3 个级别( child 的 child )做同样的事情，比如说“国家->省->城市”或“品牌->家庭->模型”

我试图扩展所有实体，但失败了

var query = from c in Service.Brands.Expand("Families,Models").. //fails,
//which even makes some sense, since Models is a Child of Family, not Brand
var query = from c in Service.Brands.Expand("Families").. //this works, 
//but Family.Models is empty

有没有办法在一个查询中执行此操作，还是必须将其拆分为两个单独的查询？

Answer 1

以下语句应返回您要查找的内容:

var query = from c in Service.Brands.Expand("Families/Models")

这将运行以下 odata 查询:

.../OData.svc/Brands?$expand=Families/Models

Here是一些进一步的 odata 文档的链接:

The syntax of a $expand query option is a comma-separated list of Navigation Properties. Additionally each Navigation Property can be followed by a forward slash and another Navigation Property to enable identifying a multi-level relationship.