LINQ to SQL - Is it true that SubmitChanges() automatically starts a transaction?

Question

I need to use transactions with LINQ to SQL and I was reading around to get familiar with it.

Is it true that SubmitChanges is already transactioned?

Answer 1

When you call SubmitChanges, LINQ to SQL examines the set of known objects to determine whether new instances have been attached to them. If they have, these new instances are added to the set of tracked objects.

Immediately before any actual changes are transmitted, LINQ to SQL starts a transaction to encapsulate the series of individual commands.

The changes to the objects are translated one by one to SQL commands and sent to the server.

At this point, any errors detected by the database cause the submission process to stop, and an exception is raised. All changes to the database are rolled back as if no submissions ever occurred.

For more info on this view the MSDN article.

Hope this helps!