in AdventureWorksMVC/Business/CategoryManager.cs [44:50]
public static ProductSubcategory GetProductSubcategoryByName(string name)
{
var cats = from cat in Common.DataEntities.ProductSubcategories
where cat.Name == name
select cat;
return cats.FirstOrDefault();
}