title: SELECT COUNT in LINQ to SQL C#
body: <p>How can I write LINQ to SQL with COUNT?</p>
  
  <p>Example:</p>
  
  <pre><code>var purch = from purchase in myBlaContext.purchases
              select purchase;
  </code></pre>
  
  <p>How can I get the count here?</p>