Convert SQL to LINQ

Question

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')

Jignesh Trivedi · Answer

hi yes.. try Entities e = new Entities(); var temp1 = from ap in e.tblEmployeeAdditionalPayData join pp in e.tblEmployeePositionData on ap.EmployeeID equals pp.EmployeeID join pd in e.tblEmployeePersonalData on pd.EmployeeID equals pp.EmployeeID where pp.ActiveCityEmployee == 'Y' && (ap.EarningsCode == 'SD3' || ap.EarningsCode == 'SD2') && pd.EmployeeID == ap.EmployeeID select new { EmployeeID = EmployeeID EarningsCode = EarningsCode OtherHours=OtherHours HourlyRate=HourlyRate OtherPay=OtherPay PerUnitOvertimeRate=PerUnitOvertimeRate EarningsFlatAmount=EarningsFlatAmount EarningsDescription=EarningsDescription }; in above query please repleace you entity object in this query entity object is e. Let me know if you face any difficulty.

Abey Varghese · Answer

Thanks for replay. That query has error. I don't see joining the tblEmployeePersonalData table.

Jignesh Trivedi · Answer

hi try var temp1 = from ap in tblEmployeeAdditionalPayData join pp in tblEmployeePositionData on ap.EmployeeID equals pp.EmployeeID where pp.ActiveCityEmployee == 'Y' && (ap.EarningsCode == 'SD3' || ap.EarningsCode == 'SD2') select new { EmployeeID = EmployeeID EarningsCode = EarningsCode OtherHours=OtherHours HourlyRate=HourlyRate OtherPay=OtherPay PerUnitOvertimeRate=PerUnitOvertimeRate EarningsFlatAmount=EarningsFlatAmount EarningsDescription=EarningsDescription }; hope this will help you.