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 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 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 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 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 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 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); }