title: Benefits of using SqlCommand.ExecuteNonQuery instead of …
body: <p>a) <code>SqlCommand.ExecuteNonQuery</code> is  used for update, insert and delete operations.
  Besides the fact that by using <code>ExecuteNonQuery</code> instead of <code>ExecuteReader</code> we automatically know there won’t be any query results returned, are there some other benefits/reasons why <code>ExecuteNonQuery</code>  should be used?</p>
  
  <p>b) Similarly, if we want a database operation to return a single value, we should use <code>ExecuteScalar</code> instead of <code>ExecuteNonquery</code> ,where with the latter result would be returned via <code>SqlParameter</code>. Is there any particular reason why we should prefer <code>ExecuteScalar</code> over <code>ExecuteNonQuery</code>? </p>
  
  <p>thanx</p>