CODEWITHSUNDEEP
linq-to-sqltransactions
André Miranda
André Miranda

Reputation: 6598

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

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?

Upvotes: 20

Views: 5243

Answers (1)

irperez
irperez

Reputation: 1777

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!

Upvotes: 40

Related Questions