public void using_query() { var products = new Products(); var seafood_products = products.Query("Select p.ProductName,c.CategoryName from Products p " + "inner join Categories c on p.categoryid = c.categoryid where c.categoryname=@0", "Seafood"); Console.WriteLine("seafood products"); foreach (var bp in seafood_products) { Console.WriteLine("{0}, {1}", bp.ProductName, bp.CategoryName); } }
public void get_products_using_all() { var products = new Products(); var all_products = products.All(where: "CategoryID = @0", columns: "ProductID, ProductName", args: 3); foreach (dynamic p in all_products) { Console.WriteLine("{0} {1}", p.ProductID, p.ProductName); } }
public void get_products_using_find_by() { dynamic products = new Products(); var beverage_products = products.FindAllBy(CategoryID: 3, UnitPrice: 5); //list products //scalar var product_count = products.Scalar("select count(*) from Products"); Console.WriteLine("product count ={0}", product_count); //join foreach (dynamic p in beverage_products) { Console.WriteLine(p.ProductName); } }
// Products products = show_all_products(); // var seafood_products = products.Query("Select p.ProductName from Products p inner join Categories c on p.categoryid = c.categoryid where c.categoryname=@0", "Seafood"); // foreach (var bp in seafood_products) { // Console.WriteLine(bp.ProductName); // } // customer_and_orders("CONSH"); // var products = new Products(); // Console.WriteLine("Total Products: {0}", products.All().Count()); // // var product_count = products.Scalar("select count(*) from Products"); // Console.WriteLine("the real count is => {0}", product_count); // // var categories = new Category(); // var category_names = categories.All(columns: "CategoryID as id, CategoryName as name"); // foreach (var categoryName in category_names) // { // Console.WriteLine("{0} -> {1}",categoryName.id,categoryName.name); // } // var beverage_products = products.All(columns:"ProductName",where: "CategoryID=@0", args: 1); // foreach (var bp in beverage_products) // { // Console.WriteLine(bp.ProductName); // } // Console.WriteLine("seafood"); // var seafood_products = products.Query("Select p.ProductName from Products p inner join Categories c on p.categoryid = c.categoryid where c.categoryname=@0", "Seafood"); // foreach (var bp in seafood_products) { // Console.WriteLine(bp.ProductName); // } // var customers_in_orders = customers.All(columns: "CustomerID, ContactName", where: "CustomerID in @customers",args:ids); // foreach (dynamic customer in customers_in_orders) // { // Console.WriteLine(customer.ContactName); // } static Products show_all_products() { var products = new Products(); var all_Products = products.All(columns: "ProductID, ProductName", where: "CategoryID = @0", args: 3); foreach (dynamic product in all_Products) { Console.WriteLine("{0} {1}", product.ProductID, product.ProductName); } var count = products.Scalar("select count(*) from Products"); Console.WriteLine("count = {0}", count); return products; }
static void OnPriceUpdated(ProductPriceUpdate update_event) { var p = new Products(); p.Update(new {UnitPrice = update_event.Price}, new {ProductId = update_event.ProductID}); }