Linq query

Question

SELECT ActionNameAVG(CASE WHEN pp.PageId=rr.GroupPageID AND GroupName='Profile' AND DisplayId='Action_View' THEN 1 ELSE 0 END) AS Rights FROM (dbo.PagePermission pp LEFT JOIN dbo.AssignRightsToRole rr ON pp.PageId=rr.GroupPageID) WHERE GroupName='Profile' AND DisplayId='Action_View' GROUP BY ActionName how to convert above query into linq???

Ramesh Maruthi · Answer

from pp in dbo.PagePermission where (String)pp. GroupName ==  Profile  && pp. DisplayId ==  Action_View  group new {pp pp. AssignRightsToRole } by new { pp. ActionName } into g select new { g.Key. ActionName  Rights = (double?)g.Average(p => ( p.pp. PageId == p.pp. AssignRightsToRole . GroupPageID && p.pp. AssignRightsToRole . GroupName=''Profile'' && p.pp. DisplayId='Action_View' ? 1 : 0)) }