select top 5 in entity framework

Question

I have

[Person]
PersonID, EmailAddress, FirstName, LastName

[OnlineAccount]
OnlineAccountID, PersonID, Nickname

Each person is allowed to have 0-* OnlineAccount.

In entity framework with C#, how do I select the top 5 Person that has the most accounts?

Answer 1

Try this:

context.PersonSet.OrderByDescending(u => u.OnlineAccounts.Count).Take(5);