Doing Cross Tab in LInq

[kingfung_lam]

Does anyone know how to do cross tab report (PIVOTE) in Linq?

I wanna translate something like :

SELECT YearofJoining, [1] as [Department-1],[2] as [Department-2],
[3] as [Department-3] FROM
(SELECT YearOfJoining,Deptid from #MyTable) p
PIVOT
( Count(DeptId) for DEPTID in ([1],[2],[3]))
AS pvt
ORDER BY Yearofjoining



into Linq