public static void A() { //<snippet3> using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) { int productId = 776; Console.WriteLine(AWEntities.GetProductRevenue(productId)); } //</snippet3> }
public static void C() { //<snippet6> using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) { int productId = 776; var details = from s in AWEntities.SalesOrderDetails where s.ProductID == productId select s; Console.WriteLine(MyClass.GetProductRevenue(details)); } //</snippet6> }
public static void D() { //<snippet9> using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) { int productId = 776; var lineTotals = AWEntities.GetDetailsById(productId).Select(d => d.LineTotal); foreach (var lineTotal in lineTotals) { Console.WriteLine(lineTotal); } } //</snippet9> }
public static void B() { using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) { var products = from p in AWEntities.Products where GetProductRevenue(from s in AWEntities.SalesOrderDetails where s.ProductID == p.ProductID select s) > 2500000 select p; foreach (var product in products) { Console.WriteLine(product.ProductID); } } }