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);
}
}
}
