Pivot/transpose in Entity framework c#

Question

Hi,
This is regarding pivot table in Entity framework c#.
In SQL server there is a concept called pivoting which converts the rows into columns and vice versa. I want to do this conversion (pivoting) using Entity Framework. i did some googling about this but almost everyone giving similar solution (Linq Expression). This approach is first retrieving all records from database and then manually converting using DataTable. the following link is one reference link for this
http://social.msdn.microsoft.com/Forums/en-US/872aa606-73bb-4c3f-8315-013cf481f28e/pivot-table-in-c-entity-framework?forum=adodotnetentityframework 
So, please any one suggest me, is there any another solution to achieve this result only in Entity Framework? 
any help would be appreciated..

Thanks,
Sampath.