static void Main(string[] args) { Customer newCustmer = new Customer(); newCustmer.CustomerID = "KULO"; newCustmer.CompanyName = "Mala"; newCustmer.ContactName = "Misoto Kulano"; newCustmer.ContactTitle = "Owner"; newCustmer.Address = "Amela str 23"; newCustmer.City = "Pelon"; newCustmer.PostalCode = "1231"; newCustmer.Country = "France"; newCustmer.Phone = "3443-4323-432"; newCustmer.Fax = "3245-243"; using (var otherDataBase = new NorthwindEntities()) { using (var dataBase = new NorthwindEntities()) { otherDataBase.Customers.Add(newCustmer); otherDataBase.SaveChanges(); dataBase.Customers.Attach(newCustmer); dataBase.Customers.Remove(newCustmer); dataBase.SaveChanges(); } } }
public static int UpdateCustomer(string customerID, Customer newCustomer) { var customerToUpdate = customers.Find(customerID); customerToUpdate.Address = newCustomer.Address; customerToUpdate.City = newCustomer.City; customerToUpdate.CompanyName = newCustomer.CompanyName; customerToUpdate.ContactName = newCustomer.ContactName; customerToUpdate.ContactTitle = newCustomer.ContactTitle; customerToUpdate.Country = newCustomer.Country; customerToUpdate.Fax = newCustomer.Fax; customerToUpdate.Phone = newCustomer.Phone; customerToUpdate.PostalCode = newCustomer.PostalCode; customerToUpdate.Region = newCustomer.Region; int returnCode = context.SaveChanges(); return returnCode; }
public static int InsertCustomer(Customer customer) { customers.Add(customer); int returnCode = context.SaveChanges(); return returnCode; }