private static void CustomerWithOrders() { var context = new AWModel.AWEntities(); var query = from c in context.Customers where c.CustomerID == 5 select new { c.CustomerID, c.FirstName, c.LastName, c.SalesOrderHeaders }; var cust = query.FirstOrDefault(); }
private static void CustomersQuery() { var context = new AWModel.AWEntities(); var query = from c in context.Customers where c.CustomerID == 5 select c; var customers = query.FirstOrDefault(); }
private static void CustomersThatHaveOrders() { var context = new AWModel.AWEntities(); var customers = context.Customers.Where(c => c.SalesOrderHeaders.Any()).ToList(); }