title: Does SqlTransaction need to have Dispose called?
body: <p>Do I need to call dispose in the finally block for SqlTransaction?  Pretend the developer didnt use USING anywhere, and just try/catch.</p>
  
  <pre><code>SqlTransaction sqlTrans = con.BeginTransaction();
  
  try
  {
       //Do Work
  sqlTrans.Commit()
  }
  catch (Exception ex)
          {
  
             sqlTrans.Rollback();
          }
  
   finally
          {
              sqlTrans.Dispose();
              con.Dispose();
          }
  </code></pre>