var query= from _t in db.E_Cat join _s in db.E_StoryDetail on _t.CatID equals _s.SCat into testSubject from _s in testSubject.DefaultIfEmpty() group _t by new {_t.CatID,_t.CatName} into g select new { CatID = g.Key.CatID, CatName=g.Key.CatName, count = g.Count() };
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)