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