asp.net-web-api - 如何将 ODataQueryOptions 与 $expand 一起使用

Question

我一直在使用以下代码将“Odata”样式参数注入(inject)查询中。这工作正常，直到我尝试使用 $expand，并且出现转换错误

无法转换类型为“System.Data.Entity.Infrastruct.DbQuery”的对象1[System.Web.Http.OData.Query.Expressions.SelectExpandBinder+SelectAllAndExpand1[STOS.Repository.Entities .Item]]' 键入“System.Collections.Generic.IEnumerable`1[STOS.Repository.Entities.Item]”。

    public static List<T> ApplyTo<T>(HttpRequestMessage request, IQueryable<T> query)
    {
        var context = new ODataQueryContext(TheEdmModel(), typeof(T));
        var newOptions = new ODataQueryOptions<T>(context, request);
        return ((IEnumerable<T>)newOptions.ApplyTo(query)).ToList();
    }

我知道当使用 $expand 时，会返回一个不同的包装类，但是如何将其转换为列表？

Answer 1

请按照此示例 https://aspnet.codeplex.com/SourceControl/latest#Samples/WebApi/OData/v3/ODataQueryableSample/ :公共(public)类 OrderController : ApiController

public IQueryable<Order> Get(ODataQueryOptions queryOptions)
{
    // Register a custom FilterByValidator to disallow custom logic in the filter query
    if (queryOptions.Filter != null)
    {
        queryOptions.Filter.Validator = new RestrictiveFilterByQueryValidator();
    }

    // Validate the query, we only allow order by Id property and 
    // we only allow maximum Top query value to be 9
    ODataValidationSettings settings = new ODataValidationSettings(){ MaxTop = 9 };
    settings.AllowedOrderByProperties.Add("Id");
    queryOptions.Validate(settings);

    // Apply the query
    return queryOptions.ApplyTo(OrderList.AsQueryable()) as IQueryable<Order>;
}