title: Reusing SqlConnection within a DAL method
body: <p>Suppose we have a DAL method</p>
  
  <pre><code>public void BuyProduct(int productId, int quantity, int buyerId);
  </code></pre>
  
  <p>Within that method we need to call 2 stored procedures:</p>
  
  <ol>
  <li>EXEC tblOrders_CreateNewOrder</li>
  <li>EXEC tblProducts_RecalculateStock</li>
  </ol>
  
  <p>Is it a good practice to create 2 SqlCommands - one per stored procedure and to use a single SqlConnection to execute those commands?</p>
  
  <p>OR</p>
  
  <p>Is it better to create a separate SqlConnection for each SqlCommand?</p>
  
  <p>So basically I am asking: <strong>is it a good practice to reuse a single SqlConnection for multiple (2-4) SqlCommands within a single DAL method</strong> (obviously reusing SqlConnection across the entire DAL would be dumb)?</p>
  
  <p>PS - please do not ask me why can't I just combine the 2 stored procedures into 1. My answer is - separation of concerns.</p>