static void Main() { var db = new NORTHWNDEntities(); var pesho = new Customer() { CustomerID = "Pesho", CompanyName = "Pesho's Company" }; // DAO.InsertCustomer(pesho, db); // DAO.DeleteCustomer(pesho.CustomerID, db); // DAO.ModifyCustomerInfo("ANATR", db, "NEW COMPANY", "Pesho"); foreach (var cust in DAO.GetCustomersByOrderDateAndShippingCountry(1997, "Canada", db)) { Console.WriteLine(cust.ContactName); Console.WriteLine(cust.Country); } Console.WriteLine(new string('=', 30)); foreach (var customerName in DAO.GetCustomersByOrderDateAndShippingCountryNativeSQL(db)) { Console.WriteLine(customerName); } Console.ReadKey(); }
public static void InsertCustomer(Customer customer, NORTHWNDEntities dataBase) { dataBase.Customers.Add(customer); dataBase.SaveChanges(); }