public ODataResult <Model.Order> TableFunctionWithParameters(String id, String name, String status)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.Order> orders = parser.ExecuteReader <Model.Order>();
return(parser.OData(orders));
}
public ODataResult <Model.Customer> Get(String country, String id)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.Customer> customers = parser.ExecuteReader <Model.Customer>();
return(parser.OData(customers));
}
public async Task Get()
{
var edmModel = (IEdmModel)_httpContextAccessor.HttpContext.RequestServices.GetService(typeof(IEdmModel));
Query.OeModelBoundProvider modelBoundProvider = OeAspHelper.CreateModelBoundProvider(edmModel, 10, false);
await OeAspQueryParser.Get(_httpContextAccessor.HttpContext, modelBoundProvider).ConfigureAwait(false);
}
public ODataResult <Model.ManyColumns> Get(int id)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.ManyColumns> manyColumns = parser.ExecuteReader <Model.ManyColumns>();
return(parser.OData(manyColumns));
}
public ODataResult <String> TableFunctionWithCollectionParameter()
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <String> items = parser.ExecuteReader <String>();
return(parser.OData(items));
}
public ODataResult <Model.OrderItem> BoundFunctionCollection(String customerNames)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.OrderItem> orderItems = parser.ExecuteReader <Model.OrderItem>();
return(parser.OData(orderItems));
}
public async Task Get()
{
var edmModel = (IEdmModel)_httpContextAccessor.HttpContext.RequestServices.GetService(typeof(IEdmModel));
Query.OeModelBoundProvider modelBoundProvider = OdataToEntityHelper.CreateModelBoundProvider(edmModel, 10);
await OeAspQueryParser.Get(_httpContextAccessor.HttpContext, modelBoundProvider);
}
public ODataResult <Model.OrderItem> GetItems(int id)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.OrderItem> orderItems = parser.ExecuteReader <Model.OrderItem>();
return(parser.OData(orderItems));
}
public ODataResult <Model.ShippingAddress> Get(int id)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.ShippingAddress> shippingAddresses = parser.ExecuteReader <Model.ShippingAddress>();
return(parser.OData(shippingAddresses));
}
public ODataResult <Model.Order> BoundFunctionSingle(String country, String id, String orderNames)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.Order> orders = parser.ExecuteReader <Model.Order>();
return(parser.OData(orders));
}
public ODataResult <Model.Order> TableFunction()
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.Order> orders = parser.ExecuteReader <Model.Order>();
return(parser.OData(orders));
}
public ODataResult <Model.Category> Get(int id)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.Category> categories = parser.ExecuteReader <Model.Category>();
return(parser.OData(categories));
}
public async Task <IActionResult> ScalarFunctionWithParameters(String id, String name, String status)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
int?result = await parser.ExecuteScalar <int>();
return(parser.OData(result));
}
public async Task <IActionResult> ScalarFunction()
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
int?result = await parser.ExecuteScalar <int>();
return(parser.OData(result));
}
public ODataResult <Model.CustomerShippingAddress> Get(String customerCountry, String customerId, int shippingAddressOrderId, int shippingAddressId)
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
IAsyncEnumerable <Model.CustomerShippingAddress> customerShippingAddresses = parser.ExecuteReader <Model.CustomerShippingAddress>();
return(parser.OData(customerShippingAddresses));
}
public ODataResult <Model.Category> Get(int id)
{
Query.OeModelBoundProvider modelBoundProvider = _httpContextAccessor.HttpContext.CreateModelBoundProvider();
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext, modelBoundProvider);
IAsyncEnumerable <Model.Category> categories = parser.ExecuteReader <Model.Category>();
return(parser.OData(categories));
}
public ODataResult <Model.Customer> Get()
{
Query.OeModelBoundProvider modelBoundProvider = _httpContextAccessor.HttpContext.CreateModelBoundProvider();
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext, modelBoundProvider);
IAsyncEnumerable <Model.Customer> customers = parser.ExecuteReader <Model.Customer>();
return(parser.OData(customers));
}
public ODataResult <Model.ShippingAddress> Get()
{
Query.OeModelBoundProvider modelBoundProvider = _httpContextAccessor.HttpContext.CreateModelBoundProvider();
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext, modelBoundProvider);
IAsyncEnumerable <Model.ShippingAddress> shippingAddresses = parser.ExecuteReader <Model.ShippingAddress>();
return(parser.OData(shippingAddresses));
}
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));
}
public async Task ResetDb()
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
await parser.ExecuteScalar <int>().ConfigureAwait(false);
}
public async Task ResetManyColumns()
{
var parser = new OeAspQueryParser(_httpContextAccessor.HttpContext);
await parser.ExecuteScalar <int>();
}
public async Task Get()
{
await OeAspQueryParser.Get(_httpContextAccessor.HttpContext, false, 10);
}
