Select most frequent value using LINQ

Question

I'm trying to select the top five most frequent values in my table and return them in a List.

    var mostFollowedQuestions = (from q in context.UserIsFollowingQuestion                                  select *top five occuring values from q.QuestionId*).toList(); 

Any idea?

Thanks

Answer 1

var mostFollowedQuestions = context.UserIsFollowingQuestion                                     .GroupBy(q => q.QuestionId)                                     .OrderByDescending(gp => gp.Count())                                     .Take(5)                                     .Select(g => g.Key).ToList(); 

Answer 2

 int[] nums = new[] { 1, 1, 1, 2, 2, 2, 3, 3, 4, 4, 5, 5, 6, 6, 7 };   IEnumerable<int> top5 = nums             .GroupBy(i => i)             .OrderByDescending(g => g.Count())             .Take(5)             .Select(g => g.Key);