in AdventureWorksMVC/Business/ProductManager.cs [33:39]
        public static Product GetProductByName(string name)
        {
            var product = from p in Common.DataEntities.Products
                          where p.Name == name 
                          select p;
            return product.FirstOrDefault();
        }