List most frequent items in the database using LINQ

Question

List most frequent items in the database using LINQ

Navigation

#1 by (2 votes)

2

I would like to list on the screen, type a ranking, the most frequent items in the database table through its name, for example:

John appears 6 times; Joseph appears 4 times; Maria appears once.

Would anyone help me?

c# entity-framework-6 asp.net-mvc

asked by anonymous 26.02.2016 / 20:12

1 answer

Why is BroadcastReceiver called several times and always with the same "extra"? How do I get all the HTML of this page as a string?

score 2 · Accepted Answer

There is not much secret:

var grupos = db.Entidade
                  .GroupBy(e => e.Nome)
                  .OrderByDescending(g => g.Count())
                  .ToList();

Each element of grupos is a special enumeration (called Grouping ) that has a Key attribute (in this case, the name of the person). That is, to get the records, you can do this:

foreach (var registros in grupos) {
    Console.WriteLine("Nome: " + registros.Key);
    foreach (registro in registros)
    {
        // Aqui vai uma lógica para lidar com cada registro.
    }
}