public long GetCompanyAndGroupProduct()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
/*
* var result = (from c in context.Customers
* join o in context.Orders on c.CustomerID equals o.CustomerID
* join od in context.Order_Details on o.OrderID equals od.OrderID
* join p in context.Products on od.ProductID equals p.ProductID
* group c by c.CompanyName into g
* select new
* {
* CompanyName = g.Key,
* ProductCount = g.Count()
* }).OrderBy(x => x.CompanyName).ToList();
*/
var result = context.Order_Details
.GroupBy(od => od.Orders.Customers.CompanyName)
.Select(g => new { CompanyName = g.Key, ProductCount = g.Count() })
.OrderBy(x => x.CompanyName)
.ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
public long GetCompanyAndBoughtProductProcedure()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
var result = context.GET_COMPANY_AND_BOUGHT_PRODUCT().ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
public long GetCustomersWith7InPhoneProcedure()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
var result = context.GET_CUSTOMERS_WITH_7_IN_PHONE().ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
public long GetCustomersWith7InPhone()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
var result = context.Customers.Where(c => c.Phone.Contains("7")).ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
public long GetAllCustomersProcedure()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
var result = context.GET_ALL_CUSTOMERS().ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
public long GetAllCustomers()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
var result = context.Customers.ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
public long GetCompanyAndBoughtProduct()
{
using (var context = new OESK_NorthwindEntities())
{
sw.Restart();
/*
* var result = (from c in context.Customers
* join o in context.Orders on c.CustomerID equals o.CustomerID
* join od in context.Order_Details on o.OrderID equals od.OrderID
* join p in context.Products on od.ProductID equals p.ProductID
* select new
* {
* CompanyName = c.CompanyName,
* ProductName = p.ProductName
* }).ToList();
*/
var result = context.Order_Details
.Select(od => new { od.Orders.Customers.CompanyName, od.Products.ProductName })
.ToList();
sw.Stop();
}
return(sw.ElapsedMilliseconds);
}
