static void UpdateCustomer(int id, string city) { using (var ctx = new NewDbContext()) { var customer = ctx.Customers .Where(c => c.Id == id) .SingleOrDefault(); customer.City = city; ctx.Entry(customer).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } }
static void DeleteCustomer(int id) { using (var ctx = new NewDbContext()) { var customer = ctx.Customers .Where(c => c.Id == id) .SingleOrDefault(); //ctx.Entry(customer).State = System.Data.Entity.EntityState.Modified; ctx.Customers.Remove(customer); ctx.SaveChanges(); } }
static void CreateCustomer() { using (var ctx = new NewDbContext()) { var customer = new Customer() { Firstname = "John", Lastname = "Smith", Email = "*****@*****.**" }; ctx.Customers.Add(customer); ctx.SaveChanges(); } }