public static void UpdateCustomer(string companyName, string updateCompanyName) { using (var db = new NorthwindEntities()) { Customer updateCustomer = GetCustomerCompanyName(db, companyName); updateCustomer.CompanyName = updateCompanyName; db.SaveChanges(); } }
public static void DeleteCustomer(string companyName) { using (var db = new NorthwindEntities()) { Customer deleteCustomer = GetCustomerCompanyName(db, companyName); db.Customers.Remove(deleteCustomer); db.SaveChanges(); } }
public static void CreateCustomer(string id, string companyName) { using (var db = new NorthwindEntities()) { Customer newCustomer = new Customer { CustomerID = id, CompanyName = companyName }; db.Customers.Add(newCustomer); db.SaveChanges(); } }
public static void FindCustomersWithOrders(string shipedCountry, int year) { using (var db = new NorthwindEntities()) { var orders = from o in db.Orders where o.Customer.Country == shipedCountry select o; foreach(var item in orders.Where(x => x.OrderDate.Value.Year == year)) { Console.WriteLine("Company name: {1} --- Order Dates: {0}", item.OrderDate.Value.ToShortDateString(), item.Customer.CompanyName); } } }
static Customer GetCustomerCompanyName(NorthwindEntities nortwindEntities, string companyName) { var result = nortwindEntities.Customers.First( x => x.CompanyName == companyName); return result; }