Linq2SQL: SubmitChanges covered by a transaction?

Question

MyDataContext context = new MyDataContext();

// do a lot of insert, deletes and updates

context.SubmitChanges();

Will all SQL genereated and executed by SubmitChanged() be covered by a transaction? How do I make sure it's covered by a transaction?

Updated:

The reason why I asking it that I having a weird bug where I suspect a transaction hasn't been used.

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.

(SQL Transactions isn't shown in my debug output?)

Answer 1

it is, and the whole thing will roll back if it fails

How to: Submit Changes to the Database (LINQ to SQL)

Answer 2

If you want everything to happen within a transaction use a Transaction Scope

http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx

Answer 3

Explicitly creating a TransactionScope is only needed when you are invoking SubmitChanges multiple times and want all of the invokations to be included in one single transaction.