title: Convert SQL statement to Linq-to-SQL with 2 columns with a count(*) not working
body: <p>I have a SQL statement that I need to convert to Linq-to-SQL.</p>
  
  <p>The SQL statement that works is</p>
  
  <pre><code>Select 
      Comment, count(*) as counted 
  from 
      [ESO].[ESO].[DOCCCOIssues] 
  group by 
      comment
  </code></pre>
  
  <p>Linq I have an issue with</p>
  
  <pre><code>var issueModel = new IssuesModel();
  
  var query = (from c in DOCCCOIssues//.IssuesModels
              //group c by c.Comment into g
              select new
              {
                  c.Comment,
                  //Count = g.Count()
              });
  </code></pre>
  
  <ol>
  <li>I know how to specify a bunch of fields</li>
  <li>I did comment out an example i saw of someone doing a group by  with a count -  not sure how to get this to work </li>
  <li>I have seen the linq queries of ONLY getting <code>select c).Count()</code>, and that is not want I want</li>
  </ol>