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?