in AdventureWorksMVC/Business/ProductManager.cs [60:66]
        public static Product GetProductByProductId(int prodId)
        {
            var prods = from p in Common.DataEntities.Product
                        where p.ProductID == prodId
                        select p;
            return prods.FirstOrDefault();
        }