static void CreateCustomer(string name) { using (var ctx = new TestEFDBFirstContext()) { var customer = new Customer() { Name = name }; ctx.Customers.Add(customer); ctx.SaveChanges(); } }
static void DeleteCustomer(int id) { using (var ctx = new TestEFDBFirstContext()) { var customer = ctx.Customers .Where(c => c.Id == id) .SingleOrDefault <Customer>(); if (customer != null) { ctx.Customers.Remove(customer); ctx.SaveChanges(); } } }
static void UpdateCustomer(int id, string name) { using (var ctx = new TestEFDBFirstContext()) { var customer = ctx.Customers .Where(c => c.Id == id) .SingleOrDefault <Customer>(); if (customer != null) { customer.Name = name; ctx.Entry(customer).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } } }