private static void CreateNorthwindTwin() { using (var db = new NorthwindEntities()) { db.Database.CreateIfNotExists(); db.SaveChanges(); } }
private static void DeleteCustomerFromCustomerTable(string customerId) { using (var db = new NorthwindEntities()) { Customer customer = GetCustomerByCustomerId(customerId, db); db.Customers.Remove(customer); db.SaveChanges(); } }
private static void ModifyCustomerInCustomerTable(string customerId, string companyName, string contactName, string contactTitle, string address, string city, string region, string postalCode, string country, string phone, string fax) { using (var db = new NorthwindEntities()) { Customer customer = GetCustomerByCustomerId(customerId, db); customer.CustomerID = customerId; customer.CompanyName = companyName; customer.ContactName = contactName; customer.ContactTitle = contactTitle; customer.Address = address; customer.City = city; customer.Region = region; customer.PostalCode = postalCode; customer.Country = country; customer.Phone = phone; customer.Fax = fax; db.SaveChanges(); } }
private static void InsertNewCustomerInCustomerTable(string customerId, string companyName, string contactName, string contactTitle, string address, string city, string region, string postalCode, string country, string phone, string fax) { using (var db = new NorthwindEntities()) { Customer newCustomer = new Customer(); newCustomer.CustomerID = customerId; newCustomer.CompanyName = companyName; newCustomer.ContactName = contactName; newCustomer.ContactTitle = contactTitle; newCustomer.Address = address; newCustomer.City = city; newCustomer.Region = region; newCustomer.PostalCode = postalCode; newCustomer.Country = country; newCustomer.Phone = phone; newCustomer.Fax = fax; db.Customers.Add(newCustomer); db.SaveChanges(); } }