I have a table called ResourceMaster containing EmployeeID as primary key, ReportingMgr along with many other column.
I want to fetch the records group by the reporting manager.
Here is my query :
var MyUsers = from users in DC.GetTable<ResourceMaster>()
group users by users.ReportingMgr into MyGroup
Gridview1.DataSource = MyUsers;
But I am getting an error " A field or property named 'Key' is not found"..
Any reply is appreciated.