This project is read-only.

Example of transaction

Oct 20, 2013 at 9:47 AM
Andy, may I ask you to update your post with an example of using transaction? Suppose I need to remove some records, insert a couple of other records and update a lot of records - all that in one transaction.
Nov 1, 2013 at 3:12 PM

I have long-standing plans to improve the documentation for this wrapper, but you know how it is… J

In the meantime, please take a look at my video from Tech Ed 2012:

If you download the slides from there and click through them, there is one slide that is about transactions.

It’s simple enough though – just execute a BEGIN TRANSACTION statement before your block of statements, then execute COMMIT TRANSACTION at the end (or ROLLBACK TRANSACTION) to discard the changes.

Nov 1, 2013 at 3:46 PM
Thanks, Andy! Slides are very useful!