title: Enterprise library manage connections
body: <p>I am building an application with c# and I decided to use the Enterprise Library for the DAL (SQL Server).</p>
  
  <p>I don't remember where, but I had read an article about EntLib which said that the connections are closed automatically.</p>
  
  <p>Is it true?</p>
  
  <p>If not, what is the best approach of managing the connections in the middle layer? 
  Open and close in each method?</p>
  
  <p>The above is a sample method of how I am using the EntLib</p>
  
  <pre><code>public DataSet ReturnSomething
  {
      var sqlStr = "select something";
      DbCommand cmd = db.GetSqlStringCommand(sqlStr);
      db.AddInParameter(cmd, "@param1", SqlDbType.BigInt, hotelID);
      db.AddInParameter(cmd, "@param2", SqlDbType.NVarChar, date);
      return db.ExecuteDataSet(cmd);
  </code></pre>
  
  <p>}</p>
  
  <p>Thanks in advance.</p>