title: What are the performance implications of using 'Using' on sqlConnections
body: <p>I came across an <a href="http://www.w3enterprises.com/articles/using.aspx" rel="nofollow noreferrer" title="article">article</a> saying that using my sqlConnection like this :</p>
  
  <pre><code>using (SqlConnection sqlConnection = new SqlConnection(Config.getConnectionString()))
              {
                  using (SqlDataAdapter dataAdapter = new SqlDataAdapter(query, sqlConnection))
                  {
                      dataAdapter.Fill(dataSet);
                  }
              }
  </code></pre>
  
  <p>increases performance because it disposes the objects at the end of your method. So i have been coding with 'Using' for a while now, after chatting with some other developers they said that that creating and destroying the instance multiple times wont really increase performance. </p>
  
  <p>What are the performance implications on the sqlserver and system resources if I am using 'Using' on all of my dataAccess methods. Will the sqlServer be hit harder because of the connection being connected and reconnected multiple times? </p>