static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter10.rental"); context.ExecuteStoreCommand("delete from chapter10.vehicle"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter6.workertask"); context.ExecuteStoreCommand("delete from chapter6.worker"); context.ExecuteStoreCommand("delete from chapter6.task"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter2.poem"); context.ExecuteStoreCommand("delete from chapter2.poet"); context.ExecuteStoreCommand("delete from chapter2.meter"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter11.invoice"); context.ExecuteStoreCommand("delete from chapter11.[order]"); // because we re-used tables in this chapter! context.ExecuteStoreCommand("delete from chapter11.customer"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter5.sectionstudent"); context.ExecuteStoreCommand("delete from chapter5.section"); context.ExecuteStoreCommand("delete from chapter5.student"); context.ExecuteStoreCommand("delete from chapter5.course"); context.ExecuteStoreCommand("delete from chapter5.instructor"); } }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter12.[user]"); } }
public Order InsertOrder() { using (var context = new EFRecipesEntities()) { // remove previous test data context.ExecuteStoreCommand("delete from chapter9.[order]"); var order = new Order { Product = "Camping Tent", Quantity = 3, Status = "Received" }; context.Orders.AddObject(order); context.SaveChanges(); return(order); } }
static void RunExample() { using (var context = new EFRecipesEntities()) { context.Agents.AddObject(new Agent { Name = "Phillip Marlowe", Phone = "202 555-1212" }); context.Agents.AddObject(new Agent { Name = "Janet Rooney", Phone = "913 876-5309" }); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { // change the phone numbers var agent1 = context.Agents.Where(a => a.Name == "Janet Rooney").Single(); var agent2 = context.Agents.Where(a => a.Name == "Phillip Marlowe").Single(); agent1.Phone = "817 353-4458"; context.SaveChanges(); // update the other agent's number out-of-band context.ExecuteStoreCommand(@"update Chapter14.agent set Phone = '817 294-6059' where name = 'Phillip Marlowe'"); // now change it using the model agent2.Phone = "817 906-2212"; try { context.SaveChanges(); } catch (OptimisticConcurrencyException ex) { Console.WriteLine("Exception caught updating phone number: {0}", ex.Message); } } using (var context = new EFRecipesEntities()) { Console.WriteLine("-- All Agents --"); foreach (var agent in context.Agents) { Console.WriteLine("Agent: {0}, Phone: {1}", agent.Name, agent.Phone); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter4.Member"); context.Members.AddObject(new Member { Name = "Robert Dewey", Email = "*****@*****.**" }); context.Members.AddObject(new Member { Name = "Nancy Steward", Email = "*****@*****.**" }); context.Members.AddObject(new Member { Name = "Robin Rosen", Email = "*****@*****.**" }); context.SaveChanges(); } } }