Abey Varghese

Abey Varghese

  • NA
  • 18
  • 7.3k

Convert SQL to LINQ

Jan 17 2013 4:08 PM
 Please help me to convert this SQL query to LINQ:

SELECT
EmployeeID, EarningsCode, OtherHours, HourlyRate, OtherPay, PerUnitOvertimeRate,
EarningsFlatAmount
, EarningsDescription
FROM
dbo.tblEmployeeAdditionalPayData
WHERE
EmployeeID IN (SELECT A.EmployeeID
FROM dbo.tblEmployeePersonalData AS A
INNER JOIN dbo.tblEmployeePositionData AS B
ON B.EmployeeID = A.EmployeeID
WHERE A.ActiveCityEmployee = 'Y')
AND
(EarningsCode = 'SD3' OR EarningsCode = 'SD2')

Answers (3)