in AdventureWorksMVC/Business/ProductManager.cs [46:53]
public static IQueryable<Product> GetProductByCategory(ProductSubcategory category)
{
IQueryable<Product> prodList = null;
prodList = from p in Common.DataEntities.Products
where p.ProductSubcategory.ProductSubcategoryID == category.ProductSubcategoryID
select p;
return prodList;
}