Click here to Skip to main content
15,887,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
select zProcessStatus.StatusName, zProcessStatus.StatusNameDari, COUNT( ProcessProgress.SchoolID) as 'Count'
 from zProcessStatus
left join ProcessProgress on ProcessProgress.ProcessStatusID=zProcessStatus.ProcessStatusID
join SubProcessStatus on zProcessStatus.ProcessStatusID=SubProcessStatus.ProcessStatusID 
where  SubProcessStatus.SubProcessID='18250478-7DA5-45D6-90A7-51DFE94B09C8'
group by  zProcessStatus.StatusName
,zProcessStatus.StatusNameDari


What I have tried:

(from zProcessStatus in _applicationContext.ZProcessStatus
                             join processProgress in _applicationContext.ProcessProgress on zProcessStatus.ProcessStatusId equals processProgress.ProcessStatusId into processprogressGroup
                             from a in processprogressGroup.DefaultIfEmpty()
                             join subProcessStatus in _applicationContext.SubProcessStatus on zProcessStatus.ProcessStatusId equals subProcessStatus.ProcessStatusId
                             where subProcessStatus.SubProcessId == subprocessid
                             select new
                             {
                                 SchoolId = a.SchoolId.ToString(),                              
                                 StatusNameDari = zProcessStatus.StatusNameDari,
                                 StatusName = zProcessStatus.StatusName,


                             }).ToList().GroupBy(x => new { x.StatusNameDari, x.StatusName }).Select(
                                g => new
                                {
                                    g.Key.StatusNameDari,
                                    g.Key.StatusName,

                                    Count = g.Count()
                                }).ToList();
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900