public static void Main() { var orderYear = 1997; var country = "Canada"; var searchedCustomers = DataAccessObjectsUtils.FindCustomersByOrderYearAndCountryWithSqlQuery(orderYear, country); foreach (var customerName in searchedCustomers) { Console.WriteLine(customerName); } }
public static void Main() { var shipRegion = "RJ"; var startDate = new DateTime(1996, 1, 1); var endDate = new DateTime(1996, 12, 30); var searchedSales = DataAccessObjectsUtils.FindSpecifiedSalesByRegionAndPeriod(shipRegion, startDate, endDate); foreach (var sale in searchedSales) { Console.WriteLine("Ship name: {0}, address: {1}, country: {2}", sale.ShipName, sale.ShipAddress, sale.ShipCountry); } }
static void ModifyTest() { var affectedRows = DataAccessObjectsUtils.ModifyCustomerCompanyName("ABCDE", "TestCompanyUpdated"); Console.WriteLine("Modify -> ({0} affected row(s))", affectedRows); }
static void DeleteTest() { var affectedRows = DataAccessObjectsUtils.DeleteCustomer("ABCDE"); Console.WriteLine("Delete -> ({0} affected row(s))", affectedRows); }
static void InsertTest() { var affectedRows = DataAccessObjectsUtils.InsertCustomer("ABCDE", "TestCompany", "TestContactName", "TestCity"); Console.WriteLine("Insert -> ({0} affected row(s))", affectedRows); }