public string Insert(Customer customer) { using (var dbContext = new NorthwindEntities()) { dbContext.Customers.Add(customer); dbContext.SaveChanges(); return customer.CustomerID; } }
public void Delete(string id) { using (var dbContext = new NorthwindEntities()) { var customer = dbContext.Customers.FirstOrDefault(c => c.CustomerID == id); if (customer != null) { dbContext.Customers.Remove(customer); dbContext.SaveChanges(); } } }
public void Update(string id, string newCompanyName) { using (var dbContext = new NorthwindEntities()) { var customer = dbContext.Customers.FirstOrDefault(c => c.CustomerID == id); if (customer != null) { customer.CompanyName = newCompanyName; dbContext.SaveChanges(); } } }
public string Insert(string customerID, string companyName) { using(var dbContext = new NorthwindEntities()) { var customer = new Customer() { CustomerID = customerID, CompanyName = companyName, }; dbContext.Customers.Add(customer); dbContext.SaveChanges(); return customer.CustomerID; } }