title: Capturing count from an SQL query
body: <p>What is the simplest way in C# (.cs file) to get the count from the SQL command </p>
  
  <pre><code>SELECT COUNT(*) FROM table_name
  </code></pre>
  
  <p>into an <code>int</code> variable?</p>