问题描述
使用的软件:
- ASP.Net Web Api 2
- OData v4
- Microsoft OData Client 6.13
请考虑以下模型:
PostalCode(编号,邮政编码)
PostalCode (Id, ZIP)
一个位置有一个 PostalCode ,一个 PostalCode 具有许多 Locations .
A Location has one PostalCode and a PostalCode has many Locations.
这是OData配置:
ODataModelBuilder builder = new ODataConventionModelBuilder();
builder.EntitySet<Location>("Locations");
builder.EntitySet<PostalCode>("PostalCodes");
config.MapODataServiceRoute(
routeName: "ODataRoute",
routePrefix: "odata",
model: builder.GetEdmModel());
模型类:
public class Location {
[Key]
public int Id { get; set; }
public String LocationName { get; set; }
public String Street { get; set; }
public int PostalCodeId { get; set; }
[ForeignKey("PostalCodeId")]
public PostalCode PostalCode { get; set; }
}
public class PostalCode {
public int Id { get; set; }
public string ZIP { get; set; }
public List<Location> Locations { get; set; }
}
在浏览器 $ expand 中调用 http://localhost:49938/odata/Locations?$ expand = PostalCode& $ orderby = LocationName
时,工作原理:
When calling http://localhost:49938/odata/Locations?$expand=PostalCode&$orderby=LocationName
in a browser $expand works:
{
"@odata.context": "http://localhost:49938/odata/$metadata#Locations",
"value": [
{
"Id": 1,
"LocationName": "My Location 1",
"Street": "Street 7",
"PostalCodeId": 1838,
"PostalCode": {
"Id": 1838,
"ZIP": "4081"
}
}
]
}
但是当我在应用程序中执行相同的请求时,它不起作用:
But when I do the same request in the application, it does not work:
Container c = new Container(new Uri("http://localhost:49938/odata/"));
var result = c.Locations
.Expand(x => x.PostalCode)
.OrderBy(x => x.LocationName)
.ToList();
当我执行此代码时, PostalCode
为 null
.
When I execute this code PostalCode
is null
.
推荐答案
Martinaut
Martinaut
新容器...
和 var结果= ...
之间是否有任何查询操作?
Is there any query operation between new Container...
and var result= ...
?
如果是,请添加以下代码:
If yes, please add the following codes:
container.MergeOption = MergeOption.OverwriteChanges;
谢谢.
这篇关于OData客户端$ expand不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!