title: Managing SQL Server Connections
body: <p>What is the the best practice for SQL connections?</p>
  
  <p>Currently I am using the following:</p>
  
  <pre><code>using (SqlConnection sqlConn = new SqlConnection(CONNECTIONSTRING))
  {
      sqlConn.Open();
      // DB CODE GOES HERE
  }
  </code></pre>
  
  <p>I have read that this is a very effective way of doing SQL connections. By default the SQL pooling is active, so how I understand it is that when the <code>using</code> code ends the <code>SqlConnection</code> object is closed and disposed but the actual connection to the DB is put in the SQL connection pool.  Am i wrong about this?</p>