title: Max count on group by - Entity Framework
body: <p>I have following two tables:</p>
  
  <pre><code>1.) Articles - [ArticleID]
  2.) ArticleComments - [CommentID], [ArticleID]
  </code></pre>
  
  <p>I want to retrieve ArticleID with maximum no. of comments e.g.</p>
  
  <pre><code>ArticleID - 2
  TotalNoOfComments - 15
  </code></pre>
  
  <p>How do I do it in Entity Framework?</p>
  
  <p>I access ArticleComments collection like following: article.ArticleComments. The following will be the object to store the result.</p>
  
  <pre><code>public class CommentStats
  {
      public int ContextId { get; set; }
      public int CommentCount { get; set; }
  }
  </code></pre>