in AdventureWorksMVC/Business/ProductManager.cs [68:76]
public static Product GetProductByProductId(int prodId, Entities entities)
{
Product prod;
var prods = from p in entities.Product
where p.ProductID == prodId
select p;
prod = prods.FirstOrDefault();
return prod;
}