Linq Count, question

Question

I have this simple query ->

var games =
from p in _oListGames
where p.Visitor == team.ID
select p

I would like to order this select with the COUNT of total games that the p.Visitor has from that list(_oListGames)

How would I do that?

I would like to order the var "games" by the numbers of visitor games they have currently.

Answer 1

UPDATE: OK, I think I understand what you're going for now. Here's one option that I think might work:

var gameCounts = _oListGames
    .Where(p => p.Visitor == team.ID)
    .GroupBy(p => p.Home)
    .Select(g => new { Opponent = g.Key, Count = g.Count() })
    .OrderByDescending(x => x.Count);

This is basically like Mark's answer but it actually gives you the counts in the results (instead of just ordering by count).

Answer 2

var games = from p in _oListGames where p.Visitor == team.ID select p;
int count = games.Count();

or you can do this.

int count = _oListGames.Count(p=>p.Visitor == team.ID);

to sort it by count of team.ID

var sortGames = games.OrderBy(s => s.Visitor.Count());

Answer 3

I'm assuming you mean order by number of visitor games that each game's home team had:

var games =
from p in _oListGames
where p.Visitor == team.ID
orderby _oListGames.Count(g => p.Home == g.Visitor) 
select p;