title: Get number of rows of a stored procedure without loop
body: <p>Using c# how can I get the number of rows of the output of a stored procedure? I am trying something without loop and without using COUNT(*) in the database. basically something like:</p>
  
  <p><code>db.Query("storedProcedure").count()</code></p>