title: How to get a group ordered by the count column
body: <p>It is hard to ask the question in plain english so I'll show what I'm trying to do.</p>
  
  <p>Here's my SQL code:</p>
  
  <pre><code>select top 100 [Name], COUNT([Name]) as total from ActivityLog  
  where [Timestamp] between '2010-10-28' and '2010-10-29 17:00'  
  group by [Name]  
  order by total desc  
  </code></pre>
  
  <p>I need to write that in LinQ. So far I have the following:</p>
  
  <pre><code>var groups = from ActivityLog log in ctx.ActivityLog
   where log.Timestamp &gt; dateFrom
   where log.Timestamp &lt;= dateTo
   group log by log.Name;
  </code></pre>
  
  <p>but I don't have the <code>COUNT(*)</code> column to sort from :(</p>