private Orders GetOrder(AdventureWorks2014Entities context, int id)
{
return(context.WorkOrder.AsNoTracking().Where(f => f.WorkOrderID == id).Select(
x => new Orders
{
Id = x.WorkOrderID,
ProductName = x.Product.Name,
Quantity = x.OrderQty,
Date = x.DueDate
}).FirstOrDefault());
}
public List <Orders> GetOrders(int iteration)
{
var listOrders = new List <Orders>();
using (var context = new AdventureWorks2014Entities())
{
for (int i = 1; i <= iteration; i++)
{
listOrders.Add(GetOrder(context, i));
}
}
return(listOrders);
}
public List <Orders> GetOrders()
{
using (var context = new AdventureWorks2014Entities())
{
var query = context.WorkOrder.AsNoTracking().Select(
x => new Orders
{
Id = x.WorkOrderID,
ProductName = x.Product.Name,
Quantity = x.OrderQty,
Date = x.DueDate
}).Take(500);
return(query.ToList());
}
}
