public void DeleteCustomersByAddress(string address) { using (RetailEntities context = new RetailEntities()) { List <Customer> entities = context.Customers.AsQueryable().Where(c => c.Address == address).ToList(); foreach (var entity in entities) { context.DeleteObject(entity); } context.SaveChanges(); } }
public void DeleteCustomersByAddress(string address) { using (RetailEntities context = new RetailEntities()) { List<Customer> entities = context.Customers.AsQueryable().Where(c => c.Address == address).ToList(); foreach (var entity in entities) { context.DeleteObject(entity); } context.SaveChanges(); } }
public void RemoveAll() { using (ObjectContext context = new RetailEntities()) { ObjectQuery <T> entities = context.CreateQuery <T>("[" + context.GetEntitySet <T>().Name + "]"); foreach (var entity in entities) { context.DeleteObject(entity); } context.SaveChanges(); } }
public void DeleteAllCustomers() { using (RetailEntities context = new RetailEntities()) { List <Customer> entities = context.Customers.AsQueryable().ToList(); foreach (var entity in entities) { context.DeleteObject(entity); } context.SaveChanges(); //context.ExecuteStoreCommand("TRUNCATE TABLE [RETAIL].[STORE].[Customer]"); } }
public void DeleteAllCustomers() { using (RetailEntities context = new RetailEntities()) { List<Customer> entities = context.Customers.AsQueryable().ToList(); foreach (var entity in entities) { context.DeleteObject(entity); } context.SaveChanges(); //context.ExecuteStoreCommand("TRUNCATE TABLE [RETAIL].[STORE].[Customer]"); } }