title: Transaction not connected, or was disconnected error
body: <p>I am getting </p>
  
  <blockquote>
    <p>"Transaction not connected, or was disconnected error"</p>
  </blockquote>
  
  <p>error when the transaction is either committed/rolled back after doing a bulk insert (along with some other operations).</p>
  
  <pre><code>using(var tran = Session.Session().BeginTransaction(IsolationLevel.Serializable))
      {
         // do something
         fullSession.Session().CreateSQLQuery(query).ExecuteUpdate();// this query bulk insert in a temp db
         // do something else
         tran.Commit()/ tran.RollBack();// if transaction is active and not already rolled back/committed
      }
  </code></pre>
  
  <p>If the query to bulk insert from a file into a temp database fails, I get this error on tran.Commit/rollback.</p>