title: Get affected rows on ExecuteNonQuery
body: <p>I am currently working on a C# project and I am running an insert query which also does a select at the same time, e.g.:</p>
  
  <pre class="lang-sql prettyprint-override"><code>INSERT INTO table (SELECT * FROM table WHERE column=date)
  </code></pre>
  
  <p>Is there a way I can see how many rows were inserted during this query?</p>