Example of transaction

Oct 20, 2013 at 8:47 AM
Andy, may I ask you to update your post http://andywigley.com/2013/06/06/sqlite-winrt-database-programming-on-windows-phone-and-windows-8/ 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 2: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: http://channel9.msdn.com/Events/TechEd/Europe/2013/WPH-B306#fbid=

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 2:46 PM
Thanks, Andy! Slides are very useful!