public async Task <ODataResult <Model.Order> > Get() { var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext); Model.OrderContext orderContext = parser.GetDbContext <Model.OrderContext>(); IAsyncEnumerable <Model.Order> orders = parser.ExecuteReader <Model.Order>(orderContext.Orders.Where(o => o.Id > 0)); List <Model.Order> orderList = await orders.OrderBy(o => o.Id).ToList(); return(parser.OData(orderList)); }
public async Task <string> Count() { Query.OeModelBoundProvider modelBoundProvider = _httpContextAccessor.HttpContext.CreateModelBoundProvider(); var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext, modelBoundProvider); Model.OrderContext orderContext = parser.GetDbContext <Model.OrderContext>(); int?count = await parser.ExecuteScalar <int>(orderContext.Orders).ConfigureAwait(false); return(count.ToString()); }
public async Task <ODataResult <Model.Order> > Get() { Query.OeModelBoundProvider modelBoundProvider = _httpContextAccessor.HttpContext.CreateModelBoundProvider(); var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext, modelBoundProvider); Model.OrderContext orderContext = parser.GetDbContext <Model.OrderContext>(); IAsyncEnumerable <Model.Order> orders = parser.ExecuteReader <Model.Order>(orderContext.Orders.AsQueryable().Where(o => o.Id > 0)); List <Model.Order> orderList = await orders.OrderBy(o => o.Id).ToListAsync().ConfigureAwait(false); return(parser.OData(orderList)); }