Convert SQL to LINQ

Abey Varghese

13y1.9kLINQ

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
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 Varghese13y ago
Thanks for replay. That query has error. I don't see joining the "tblEmployeePersonalData" table.
Jignesh Trivedi13y ago
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.