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