in AdventureWorksMVC/Business/CategoryManager.cs [31:37]
public static ProductCategory GetCategoryByName(string name)
{
var cats = from cat in Common.DataEntities.ProductCategories
where cat.Name == name
select cat;
return cats.FirstOrDefault();
}