[Solved] How to convert sql query to LINQ query?


your SQL to LINQ look like this:- try this

from po1 in PO
   join pu in POUnit on po1.POID equals pou.POID
   join s in Scope on pou.ScopeCodeID equals s.ScopeID
   join t in Timesheet on s.ScopeID equals t.ScopeID
   join pr in Projects on s.ProjectID equals pr.ProjectID
   where s.ProjectID = 1
   group by s.ScopeID
   Select new 
     {
        SumofNH = SUM(t.NH),
        soumofT1 = SUM(t.[T1.5]),
        SumOfDT = SUM(t.DT),
        Amount = SUM(pu.Amount), 
        scopeId = s.ScopeID
     }

solved How to convert sql query to LINQ query?