如何在.ashx上手动创建ODataQueryOptions [英] how can manual create a ODataQueryOptions on .ashx

问题描述

我想重建我的上一个项目.过去，我没有使用任何Web API.我可以使用ODataQueryOptions来执行$ filter，$ orderby，$ top，$ skip吗在我自己的handler.ashx中查询?诸如此类的东西.

i would like to reconstruction my last project. in past, i did't use any Web API. can i just use the ODataQueryOptions to do $filter, $orderby , $top ,$skip for my query in my own handler.ashx ? some thing like.

var option = new ODataQueryOptions(request.params);
var query = option.ApplyTo(db.products);

推荐答案

基于上面sfuqua的回答，我创建了自己的帮助器类，该类基于Odata Uri构建OdataQueryOptions类:

Based on sfuqua's answer above I made my own helper class that builds OdataQueryOptions class based on Odata Uri:

using System.Linq;
using System.Net.Http;
using System.Web.Http.OData;
using System.Web.Http.OData.Builder;
using System.Web.Http.OData.Query;

namespace OdataHelpers
{
    public static class ODataBuilder<T>
    {
        public static ODataQueryOptions<T> BuildOptions(string oDataUri)
        {
            var baseUri = "";
            var odUri = "";
            var spl = oDataUri.Split('?');
            if (spl.Count() == 0)
                odUri = spl[0];
            else
            {
                baseUri = spl[0];
                odUri = spl[1];
            }
            if (string.IsNullOrEmpty(baseUri))
                baseUri = "http://localhost/api/" + typeof(T).Name;
            var request = new HttpRequestMessage(HttpMethod.Get, baseUri + "?" + oDataUri.Replace("?", ""));
            var modelBuilder = new ODataConventionModelBuilder();
            modelBuilder.AddEntity(typeof(T));
            var edmModel = modelBuilder.GetEdmModel();
            var oDataQueryContext = new ODataQueryContext(edmModel, typeof(T));
            return new ODataQueryOptions<T>(oDataQueryContext, request);
        }
    }
}

示例用法:

var OdataStuff = ODataBuilder<CustomerIntView>.BuildOptions("$orderby=Id");

这篇关于如何在.ashx上手动创建ODataQueryOptions的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！