static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter10.authorbook"); context.ExecuteStoreCommand("delete from chapter10.author"); context.ExecuteStoreCommand("delete from chapter10.book"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter5.appointment"); context.ExecuteStoreCommand("delete from chapter5.doctor"); context.ExecuteStoreCommand("delete from chapter5.patient"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter15.[order]"); context.ExecuteStoreCommand("delete from chapter15.customer"); context.ExecuteStoreCommand("delete from chapter15.orderstatustype"); context.ExecuteStoreCommand("delete from chapter15.shippingtype"); } }
static void RunExample() { using (var context = new EFRecipesEntities()) { // insert our lookup values context.ExecuteStoreCommand("insert into chapter15.orderstatustype(OrderStatusTypeId, Description) values (1,'Processing')"); context.ExecuteStoreCommand("insert into chapter15.orderstatustype(OrderStatusTypeId, Description) values (2,'Shipped')"); context.ExecuteStoreCommand("insert into chapter15.shippingtype(ShippingTypeId, Description) values (1,'UPS')"); context.ExecuteStoreCommand("insert into chapter15.shippingtype(ShippingTypeId, Description) values (2,'FedEx')"); } using (var context = new EFRecipesEntities()) { var c1 = new Customer { FirstName = "Robert", LastName = "Jones" }; var o1 = new Order { OrderDate = DateTime.Parse("11/19/2009"), OrderStatusTypeId = 2, ShippingTypeId = 1, Customer = c1 }; var o2 = new Order { OrderDate = DateTime.Parse("12/13/09"), OrderStatusTypeId = 1, ShippingTypeId = 1, Customer = c1 }; var c2 = new Customer { FirstName = "Julia", LastName = "Stevens" }; var o3 = new Order { OrderDate = DateTime.Parse("10/19/09"), OrderStatusTypeId = 2, ShippingTypeId = 2, Customer = c2 }; context.Customers.AddObject(c1); context.Customers.AddObject(c2); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { context.ContextOptions.LazyLoadingEnabled = true; foreach (var c in context.Customers) { Console.WriteLine("{0} has {1} order(s)", c.FullName, c.TotalOrders.ToString()); foreach (var o in c.Orders) { Console.WriteLine("\tOrdered on: {0}", o.OrderDate.ToShortDateString()); Console.WriteLine("\tStatus: {0}", o.OrderStatus); Console.WriteLine("\tShip via: {0}\n", o.ShippingType); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("insert into chapter2.account (DeletedOn,AccountHolderId) values ('2/10/2009',1728)"); var account = new Account { AccountHolderId = 2320 }; context.Accounts.AddObject(account); account = new Account { AccountHolderId = 2502 }; context.Accounts.AddObject(account); account = new Account { AccountHolderId = 2603 }; context.Accounts.AddObject(account); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { foreach (var account in context.Accounts) { Console.WriteLine("Account Id = {0}", account.AccountHolderId.ToString()); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter2.account"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter11.movierental"); } }