public IQueryable <Users> GetTopUsers()
{
var UserRaitingArranged = from RaitingRecords in Db.UserRaiting
group RaitingRecords by RaitingRecords.UserID
into ResultTable
select new { Key = ResultTable.Key, Raiting = ResultTable.Sum(value => value.Rating) };
IQueryable <Users> TopUser = (from UserRecord in Db.Users
join EachRecord in UserRaitingArranged on UserRecord.UserID equals EachRecord.Key
orderby EachRecord.Raiting descending
select UserRecord).Take(12);
return(TopUser);
}
