LINQtoSQL101_04_08 - Understanding SubmitChanges and Transactions
Tags:
In this video we'll look at what goes on when you call SubmitChanges. I've hinted at this in the previous videos, but I want to drive home the idea that every time you queue up changes using InsertOnSubmit, or DeleteOnSubmit, or make a change to an entity's properties ... all of those changes are added to a ChangeList that get translated into T-SQL and executed against the target database. However, all of those commands are wrapped in a transaction, so if one operation fails, they all fail. We'll use SQL Profiler to watch the transaction behavior as we cause our application to purposefully fail when executing CRUD operations.
Honestly, this video probably should have been in lesson 1, so I apologize for waiting until now. Hopefully this will answer any questions you had in your mind about how it works.
Downloads:
Sign up today to access downloads.
 |
LINQtoSQL101_04_08 - Understanding SubmitChanges and Transactions
Duration:
8 Minutes, 15 Seconds
Size:
10.41M
Recorded Using:
Visual Studio 2008 (all versions)
|
|
Get Free Videos via Email
Sign up for our newsletter and receive links to free videos and more.
We don't rent/sell/or commit other evil deeds with your email address. See our
Privacy Policy.
|