public long GetCustomerAndOrdersByEmp(int empID)
{
Stopwatch clock = new Stopwatch();
clock.Start();
List <Order> result;
using (IDbConnection db = new SqlConnection(connString))
{
result = db.Query <Order, Employee, Customer, Order>(Constants.GET_ENTIRE_ORDER,
(order, employee, customer) =>
{
order.Employee = employee;
order.Customer = customer;
return(order);
},
new { EmployeeID = empID },
splitOn: "EmployeeID, CustomerID").ToList();
}
clock.Stop();
var elapsedTime = clock.ElapsedMilliseconds;
ResultComparer.GetCustomerAndOrdersByEmp(result, method);
return(elapsedTime);
}
public long GetCustomerAndOrdersByEmp(int empId)
{
Stopwatch clock = new Stopwatch();
clock.Start();
List <Order> result;
using (NwEntityContext context = new NwEntityContext())
{
result = context.Orders.Include(x => x.Customer).Include(x => x.Customer).Include(x => x.Employee).Where(x => x.Employee.EmployeeID == empId).ToList();
}
clock.Stop();
var elapsedTime = clock.ElapsedMilliseconds;
ResultComparer.GetCustomerAndOrdersByEmp(result, method);
return(elapsedTime);
}
public long GetCustomerAndOrdersByEmp(int empId)
{
Stopwatch clock = new Stopwatch();
clock.Start();
var query = from order in db.Orders
join customer in db.Customers on order.CustomerID equals customer.CustomerID
join employee in db.Employees on order.EmployeeID equals employee.EmployeeID
where employee.EmployeeID == empId
select order;
query.ToList();
clock.Stop();
var elapsedTime = clock.ElapsedMilliseconds;
ResultComparer.GetCustomerAndOrdersByEmp(query.ToList(), method);
return(elapsedTime);
}
