public ActionResult GetProductReviewsFast(int productId = 1)
{
var awContext = new AdventureWorks();
var productReviews = awContext.ProductReviews.Where(p => p.ProductID == productId).ToList();
return View("Index");
}
public ActionResult Test2()
{
var awContext = new AdventureWorks();
var customer = awContext.Customers.Where(x => x.CustomerID == 10).Single();
return View("Index");
}
public JsonResult GetProductsFullList()
{
var awContext = new AdventureWorks();
var productFullList = awContext.Products.Include(p => p.ProductInventories).ToList();
var inventoryCount = productFullList.Count(p => p.ProductInventories.Count() > 1);
return Json("Success!", JsonRequestBehavior.AllowGet);
}
public ActionResult Test1()
{
var awContext = new AdventureWorks();
var customers = awContext.Customers.ToList();
var customer = customers.Where(x => x.CustomerID == 10).Select(x => x);
return View("Index");
}
public ActionResult AnyQuery()
{
var awContext = new AdventureWorks();
var query = awContext.SalesOrderDetails.Any(x => x.SalesOrderHeader.Customer.Person.LastName == "Johnson");
var queryTextModel = new QueryTextModel() { QueryText = "AnyQuery" };
return View("QueryText", queryTextModel);
}
public ActionResult GetProductReviews(int productId = 1)
{
var awContext = new AdventureWorks();
var product = awContext.Products.Include(p => p.ProductReviews).Single(p => p.ProductID == productId);
var productReviews = product.ProductReviews;
return View("Index");
}
public ActionResult Test3()
{
var awContext = new AdventureWorks();
var customer = awContext.Customers.Where(x => x.CustomerID == 29825).First();
var orders = customer.SalesOrderHeaders.ToList();
var total = orders.Sum(x => x.SubTotal);
return View("Index");
}
public ActionResult GetProductsBigInclude()
{
var awContext = new AdventureWorks();
var productFullList = awContext.Products
.Include(p => p.ProductVendors)
.Include(p => p.ProductVendors.Select(pi => pi.Vendor))
.ToList();
return Json("Success!", JsonRequestBehavior.AllowGet);
}
public ActionResult DefaultIfEmptyQuery()
{
var awContext = new AdventureWorks();
var person = new Person()
{
LastName = "Sakson"
};
var people = awContext.People.Where(x => x.LastName == "Sakson").ToList().DefaultIfEmpty(person);
var queryTextModel = new QueryTextModel() { QueryText = people.First().LastName };
return View("QueryText", queryTextModel);
}
public ActionResult EagerLoadQuery(int id)
{
// 51739
var awContext = new AdventureWorks();
var query = awContext.SalesOrderHeaders
.Where(x => x.SalesOrderID == id)
.Include(x => x.SalesOrderDetails)
.FirstOrDefault();
var salesOrderDetails = query.SalesOrderDetails.Where(x => x.UnitPrice > 100).ToList();
var queryTextModel = new QueryTextModel() { QueryText = "EagerLoadQuery" };
return View("QueryText", queryTextModel);
}
public ActionResult EagerLoadForEachQuery()
{
var awContext = new AdventureWorks();
var query = awContext.SalesOrderHeaders
.Include(x => x.SalesOrderDetails)
.Take(1000);
var totalUnitPrice = 0m;
foreach (var order in query)
{
foreach (var detail in order.SalesOrderDetails)
{
totalUnitPrice += detail.UnitPrice;
}
}
var queryTextModel = new QueryTextModel() { QueryText = "LazyLoadForEachQuery" };
return View("QueryText", queryTextModel);
}
public ActionResult SingleQuery()
{
var awContext = new AdventureWorks();
var query = awContext.SalesOrderDetails.Single(x => x.SalesOrderHeader.Customer.Person.LastName == "Sacksteder");
var queryTextModel = new QueryTextModel() { QueryText = "SingleQuery" };
return View("QueryText", queryTextModel);
}
public ActionResult SeeEFQueryWithToString()
{
var awContext = new AdventureWorks();
var query = awContext.Customers
.Where(x => x.Person.LastName == "Johnson")
.Include(x => x.SalesOrderHeaders)
.Include(x => x.Person);
var queryTextModel = new QueryTextModel() { QueryText = query.ToString() };
return View("QueryText", queryTextModel);
}
public ActionResult LazyLoadDisposedContextQuery()
{
SalesOrderHeader query;
var queryTextModel = new QueryTextModel();
using (var awContext = new AdventureWorks())
{
query = awContext.SalesOrderHeaders
.Where(x => x.SalesOrderID == 51739)
.FirstOrDefault();
}
try
{
var salesOrderDetail = query.SalesOrderDetails.Where(x => x.UnitPrice > 100).ToList();
}
catch(Exception ex)
{
queryTextModel.QueryText = ex.Message;
return View("QueryText", queryTextModel);
}
queryTextModel.QueryText = "Never going to get here.";
return View("QueryText", queryTextModel);
}
public ActionResult InsertProductReviews(int count, int productId = 1)
{
var awContext = new AdventureWorks();
var timer = Stopwatch.StartNew();
for (var i = 0; i < count; i++)
{
awContext.ProductReviews.Add(new ProductReview()
{
Comments = "test",
EmailAddress = "*****@*****.**",
ProductID = productId,
ModifiedDate = DateTime.Now,
Rating = 3,
ReviewDate = DateTime.Now.AddDays(5),
ReviewerName = "John Wiegert"
});
}
awContext.SaveChanges();
timer.Stop();
var time = timer.Elapsed;
return View("Index", (object)time.ToString());
}
// GET: Optimization
public ActionResult GetProductsList()
{
var awContext = new AdventureWorks();
var productList = awContext.Products.Select(p => new ProductListModel()
{
Name = p.Name,
ListPrice = p.ListPrice,
ProductID = p.ProductID,
InventoryCount = p.ProductInventories.Count()
}).ToList();
var inventoryCount = productList.Count(p => p.InventoryCount > 1);
return Json("Success!", JsonRequestBehavior.AllowGet);
}
public ActionResult GetTransactionHistoryNoChangesList()
{
var awContext = new AdventureWorks();
var timer = Stopwatch.StartNew();
var productFullList = awContext.TransactionHistories.AsNoTracking().ToList();
timer.Stop();
var time = timer.Elapsed;
return Json("Success!", JsonRequestBehavior.AllowGet);
}
public ActionResult UpdateProductsList()
{
var awContext = new AdventureWorks();
awContext.Configuration.AutoDetectChangesEnabled = true;
var productFullList = awContext.Products.Take(2).ToList();
var random = new Random();
foreach (var product in productFullList)
{
product.Weight = random.Next();
}
awContext.SaveChanges();
return Json("Success!", JsonRequestBehavior.AllowGet);
}
public ActionResult InsertProductReviewsFast(int count, int commitCount)
{
var awContext = new AdventureWorks();
var firstProduct = awContext.Products.Select(p => p.ProductID).First();
var timer = Stopwatch.StartNew();
awContext.Configuration.AutoDetectChangesEnabled = false;
awContext.Configuration.ValidateOnSaveEnabled = false;
for (var i = 0; i < count; i++)
{
awContext.ProductReviews.Add(new ProductReview()
{
Comments = "test",
EmailAddress = "*****@*****.**",
ProductID = firstProduct,
ModifiedDate = DateTime.Now,
Rating = 3,
ReviewDate = DateTime.Now.AddDays(5),
ReviewerName = "John Wiegert"
});
if (i % commitCount == 0)
{
awContext.SaveChanges();
}
}
awContext.SaveChanges();
timer.Stop();
var time = timer.Elapsed;
return View("Index", (object)time.ToString());
}
public ActionResult IncludeQuery()
{
var awContext = new AdventureWorks();
var query = awContext.SalesOrderDetails
.Where(x => x.SalesOrderHeader.Customer.Person.LastName == "Johnson")
.Include(x => x.SalesOrderHeader)
.Include(x => x.SalesOrderHeader.Customer.Person)
.Include(x => x.SalesOrderHeader.Customer.Person.PersonPhones)
.Include(x => x.SalesOrderHeader.Customer.Person.EmailAddresses).ToList();
var queryTextModel = new QueryTextModel() { QueryText = "IncludeQuery" };
return View("QueryText", queryTextModel);
}
public ActionResult EFCasingQuery()
{
var awContext = new AdventureWorks();
var lower = awContext.People.Where(x => x.LastName == "Johnson").ToList().Count;
var upper = awContext.People.Where(x => x.LastName == "JOHNSON").ToList().Count;
var mixed = awContext.People.Where(x => x.LastName == "JoHnSON").ToList().Count;
var queryTextModel = new QueryTextModel() { QueryText = "EFCasingQuery" };
return View("QueryText", queryTextModel);
}
public ActionResult Index()
{
var awContext = new AdventureWorks();
var products = awContext.Products.Take(2).ToList();
return View();
}