need help to convert Select to LINQ or lambda

[zleug]

Hi All.

I need help to convert SQL select to LINQ and lambda

SELECT
et.EmployeeDeptId,
et.IsAllowed,
et.CreatedDate,
et.CreatedBy,
et.UpdatedDate,
et.UpdatedBy
FROM EmployeeTask et
JOIN EmployeeDept ed
ON et.EmployeeDeptId = ed.Id
WHERE et.EmployeeDeptId = (SELECT id FROM EmployeeDept ed
WHERE ed.Id=edid)
where edid is variable.

Thanks,

Continue reading...