public static void Main() { using (var db = new NorthwindEntities()) { // 2. Create a DAO class with static methods which provide functionality for inserting, modifying and deleting customers. Customer customer = new Customer(); customer.CompanyName = "GhostBustersLTD"; customer.CustomerID = "202"; DAO.InsertCustomer(customer, db); Customer anotherCustomer = new Customer(); anotherCustomer.CompanyName = "GhostBustersLTD"; anotherCustomer.CustomerID = "203"; DAO.InsertCustomer(anotherCustomer, db); DAO.DeleteCustomer("202", db); DAO.ModifyCustomer("203", "Alcoholics Anonymous", db); // 3. Write a method that finds all customers who have orders made in 1997 and shipped to Canada. var salesToCanada1997 = SalesOperations.FindOrdersByYearAndShipCountry(1997, "Canada", db); foreach (var sales in salesToCanada1997) { Console.WriteLine(sales.ContactName); Console.WriteLine(sales.Country); } // 4. Implement previous by using native SQL query and executing it through the DbContext. SalesOperations.FindOrdersByYearAndShipCountryNativeSQL(1997, "Canada", db); // 5. Write a method that finds all the sales by specified region and period (start / end dates). SalesOperations.FindSalesByRegionByPeriod(new DateTime(1996, 01, 01), new DateTime(1997, 12, 31), "BC", db); 8. By inheriting the Employee entity class create a class which allows employees to access their corresponding territories as property of type EntitySet<T>.
public static void InsertCustomer(Customer customer, NorthwindEntities db) { db.Customers.Add(customer); db.SaveChanges(); }