title: Linq2SQL: SubmitChanges covered by a transaction?
body: <pre><code>MyDataContext context = new MyDataContext();
  
  // do a lot of insert, deletes and updates
  
  context.SubmitChanges(); 
  </code></pre>
  
  <p>Will all SQL genereated and executed by SubmitChanged() be covered by a transaction? How do I make sure it's covered by a transaction?</p>
  
  <p>Updated:</p>
  
  <p>The reason why I asking it that I having a weird bug where I suspect a transaction hasn't been used.</p>
  
  <p>The procedure is about 500 inserts and a final update on one record. Sometimes the update (and perhaps a few of the insert...) isn't registered in the database. </p>
  
  <p>(SQL Transactions isn't shown in my debug output?)</p>