title: How to count group of records using LINQ Query?
body: <p>I have a database table that have a structure like this:</p>
  
  <ul>
  <li><strong>ID</strong> <em>Integer Auto Incresement</em></li>
  <li><strong>Name</strong> <em>VarChar</em></li>
  <li><strong>Status</strong> <em>VarChar</em></li>
  </ul>
  
  <p>Sample records:</p>
  
  <pre><code>ID      Name            Status
  1       record 1        Outstanding
  2       record 2        Outstanding
  3       record 3        Aging
  4       record 4        Outstanding
  5       record 5        Aging
  6       record 6        Outstanding
  </code></pre>
  
  <p>In the table, there are two main status: "Outstanding" and "Aging". I want to count how many records with status of "Outstanding" and how many records with status of "Aging" available in the table.</p>
  
  <p>This is a sample LINQ Query:</p>
  
  <pre><code>Using DC = DataClassesDataContext.Create()
          Dim dataTable = From Count(Outstanding), Count(Aging) In DC.MyTable _
                          Where item.Status = "Outstanding" OrElse item.Status = "Aging" _
                          Group By item.Status _
                          Select item
  End Using
  </code></pre>
  
  <p>The expected result should be:</p>
  
  <pre><code>Outstanding     Aging
  4               2
  </code></pre>
  
  <p>Can you help me to design a LINQ to achive the result?</p>