static void Main() { foreach (var customer in DataAccessObjectsClass.Customers_With_Orders_In_1997_Shipped_To_Canada_Sql_View()) { Console.WriteLine(customer.CustomerID); } }
static void Main() { var region = "SP"; var startDate = new DateTime(1995, 5, 10); var endDate = new DateTime(1996, 12, 4); var orders = DataAccessObjectsClass.Sales_By_Specified_Region_And_Date_Period_View(region, startDate, endDate); foreach (var order in orders) { Console.WriteLine(order.OrderID); } }
private static void TestInsertMethod() { var customer = new Customer() { CustomerID = "TEST", CompanyName = "UNKNOWN", ContactName = "UNNAMED", ContactTitle = "NO-TITLE" }; var affectedRows = DataAccessObjectsClass.InsertCustomer(customer); Console.WriteLine("\rInsert -> ({0} affected row(s))", affectedRows); }
static void TestDeleteMethod() { var affectedRows = DataAccessObjectsClass.DeleteCustomer("TEST"); Console.WriteLine("Delete -> ({0} affected row(s))", affectedRows); }
static void TestModifyMethod() { var affectedRows = DataAccessObjectsClass.ModifyCustomerCompanyName("TEST", "NEW-NAME"); Console.WriteLine("Modify -> ({0} affected row(s))", affectedRows); }
static void TestInsertMethod() { var affectedRows = DataAccessObjectsClass.InsertCustomer("TEST", "UNKNOWN", "UNNAMED", "NO-TITLE"); Console.WriteLine("Insert -> ({0} affected row(s))", affectedRows); }