static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter3.accident"); context.ExecuteStoreCommand("delete from chapter3.worker"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter5.ceo"); context.ExecuteStoreCommand("delete from chapter5.projectmanager"); context.ExecuteStoreCommand("delete from chapter5.supervisor"); context.ExecuteStoreCommand("delete from chapter5.associate"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter13.member"); } }
static void RunExample() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand(@"insert into chapter13.member(name,salary) values ('Steven Jones',45000)"); context.ExecuteStoreCommand(@"insert into chapter13.member(name,salary) values ('Kathy Kurtz', 85000)"); context.ExecuteStoreCommand(@"insert into chapter13.member(name,salary) values ('Aaron McCabe', 82000)"); } using (var context = new EFRecipesEntities()) { var upperclass = context.Members.OfType <UpperClass>(); foreach (var member in upperclass) { Console.WriteLine("{0}", member.Name); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void Main(string[] args) { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter6.weborder"); } using (var context = new EFRecipesEntities()) { var order = new WebOrder { CustomerName = "Jim Allen", OrderDate = DateTime.Parse("5/3/2009"), IsDeleted = false, Amount = 200 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "John Stevens", OrderDate = DateTime.Parse("1/1/2006"), IsDeleted = false, Amount = 400 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "Russel Smith", OrderDate = DateTime.Parse("1/3/2006"), IsDeleted = true, Amount = 500 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "Mike Hammer", OrderDate = DateTime.Parse("3/6/2006"), IsDeleted = true, Amount = 1800 }; context.WebOrders.AddObject(order); order = new WebOrder { CustomerName = "Steve Jones", OrderDate = DateTime.Parse("1/1/2003"), IsDeleted = true, Amount = 600 }; context.WebOrders.AddObject(order); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Orders"); Console.WriteLine("======"); foreach (var order in context.WebOrders) { Console.WriteLine("\nCustomer: {0}", order.CustomerName); Console.WriteLine("OrderDate: {0}", order.OrderDate.ToShortDateString()); Console.WriteLine("Is Deleted: {0}", order.IsDeleted.ToString()); Console.WriteLine("Amount: {0}", order.Amount.ToString("C")); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter15.creditreport"); context.ExecuteStoreCommand("delete from chapter15.creditriskorder"); context.ExecuteStoreCommand("delete from chapter15.creditriskcustomer"); context.ExecuteStoreCommand("delete from chapter15.preferredOrder"); context.ExecuteStoreCommand("delete from chapter15.customerdiscount"); context.ExecuteStoreCommand("delete from chapter15.preferredcustomer"); } }