Which Of The Following Code In Linq Performs Functionality #460

var categoryProducts = from c in db.Categories select new {c.CategoryName, productCount = products.Count()}; foreach (var cp in categoryProducts) { Console.WriteLine("There are {0} products in category {1}", cp.CategoryName, cp.productCount); } 

var categoryProducts = from c in db.Categories join p in db.Products on c.CategoryID equals p.CategoryID into products foreach (var cp in categoryProducts) { Console.WriteLine("There are {0} products in category {1}", cp.CategoryName, cp.productCount); }