title: linq query to select top 10 entries with most comments from the table
body: <p>I have two tables "POSTS" and "COMMENTS". One post can have many comments and I want to be able to select the top 10 posts with highest number of comments. The post_id is a FK in the comments table. I am using Linq to SQL. Please advise me on how to do this . Thanks in advance.</p>
  
  <p><strong>EDIT</strong></p>
  
  <pre><code>var top = (from q in db.question_tables
                     from a in db.answer_tables
                     where q.QUEST_ID.Equals(a.ANS_QUEST_ID)
                     orderby q.QUEST_TEXT.Count() descending
                     select new
                     {
                         QUEST_TEXT = q.QUEST_TEXT
  
  
                     }).Take(10);
  </code></pre>
  
  <p>this is how my linq query looks like now , its giving an error "Sequence operators not supported for type 'System.String'. " . :/</p>