2
Reply

SQL to LINQ Help

David Smith

David Smith
Nov 21 2012 3:06 PM
1.9k
I am really struggling transferring this SQL to linq below, can someone help me


SELECT        tblService.FilledByID, SUM(refServiceType.ServiceTypeAvgHours) AS TotalHrs
FROM            (tblService INNER JOIN
                         refServiceType ON tblService.ServiceType = refServiceType.ServiceTypeID)
WHERE        (tblService.ServiceStatus <> 5) AND (tblService.ServiceStatus <> 7) AND (tblService.ServiceDateStart BETWEEN NOW() AND NOW() - 30)
GROUP BY tblService.FilledByID

Answers (2)
Next Recommended Forum