title: C# static SQLConnection
body: <p>Shall we reuse an Static SqlConnection in a class,or its better create a instance of it?</p>
  
  <pre><code>FactoryDB factory = 
      FactoryDB.GetInstance("sp_select_regional", TipoExecucao.StoredProcedure,
          "portal_sadiaConnectionString");
  
  factory.AutoReset = true;
  
  using (FactoryDB.Conn)
  {
      factory.ParametersCount = 1;
      factory.Parameters[0] = 
          FactoryDB.CreateParameter(((IMarcas)Comentario).IDMarca, 
              'I', "@int_id_marca");
  
      factory.AddParameters();
  
      foreach (DataRow drFilial in factory.GetData().Rows)
      {
          Regionias filial = new Regionias()
          {
              IDRegional = Convert.ToInt32(drFilial["int_id_regional"]),
              TxtRegional = drFilial["txt_regional"].ToString()
          };
  
          lstRegional.Add(filial);
      }
  
      return lstRegional;
  }
  </code></pre>
  
  <p>In this example "using" use an static SqlConnection from FactoryDB class,which use SingleTon pattern to get the unique instance of it.</p>
  
  <p>I wonder if is correct to use Connection like this,cause if a want to execute another query in DB,i need to set the "FactoryDB.Conn" propertie to NULL.</p>