title: mysql connector in a multi-threaded environment
body: <p>I have a c# server that is connecting to a mysql server for data.  This c# server is a backend server for a game, that has an open thread for every player currently logged in.  How do I go about doing the mysql connection, an open connection for each thread?  A single connection using locking for all threads?</p>
  
  <p>I read somewhere that there is a 'threadpool' for this.  Is that true?  If so, is this the proper way to use it:</p>
  
  <pre><code>using(var conn = new MySqlConnection(DatabaseHelper.getConnectionString()))
  using (var cmd = conn.CreateCommand())
  {
      conn.Open();
      cmd.CommandText = "SELECT username FROM characters WHERE id=1";
      using (var reader = cmd.ExecuteReader())
      {
          while (reader.Read())
          {
              user = reader.GetString("username");
          }
      }
  }
  </code></pre>