title: SQL Server connection management with C#
body: <p>I have a C# application that has been running just fine for the past year. However, in the past couple of months we have added more clients and the database has been reporting connection errors on a more consistent basis. It might be time to revisit the way connections are handled and perhaps there is a better way to do this. Here is the class that manages my connections:</p>
  
  <pre><code>public class myDAL
      {
          protected SqlConnection sqlConnection = new SqlConnection();
  
          protected void openConnection(string connection)
          {
                  sqlConnection.ConnectionString = connection;
                  sqlConnection.Open();            
          }
  
  
          protected void closeConnection()
          {            
              sqlConnection.Close();
          }
  
  }
  </code></pre>
  
  <p>Note that I'm really doing nothing special to manage the connection. I just call the open and close as needed and this is happening from multiple clients at the same time. Am I doing anything obviously wrong here?</p>