score:0

Accepted answer
var list = (from tbbthread in context.bthread
            group tbbthread by tbbthread.id into btmp
            orderby btmp.sum(x => x.count)
            select new bviewmodel
            {
                id = btmp.key,
                count = btmp.sum(x => x.count)
            }).take(10).tolist();

More Query from same tag