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