title: This SqlTransaction has completed; it is no longer usable
body: <p>I am using Linq to SQL with SQL Server 2008 SP2, my application is WinForm .net 4
  I am importing into SQL Server 200,000 records.
  I am creating the objects and attach them to the datacontext on the "insertonsubmit".
  I then do "submitChanges" every 100 records.
  I have NO TRANSACTION what so ever.</p>
  
  <p>I get this error</p>
  
  <pre><code> "This SqlTransaction has completed; it is no longer usable." with stack
  at System.Data.SqlClient.SqlTransaction.ZombieCheck()
     at System.Data.SqlClient.SqlTransaction.Rollback()
     at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
     at System.Data.Linq.DataContext.SubmitChanges()
  </code></pre>
  
  <p>Out of the blue.
  That error is not consistent, it may appear after 10,000 records or 27,200 records or XXX records.</p>
  
  <p>Because error appears to be random, I was thinking it has something to do with the garbage collection...</p>
  
  <p>Anyone has a clue?</p>