Transaction processing for databases is one of those things I have always been ashamed that I never used – though in most of my small applications, I only do one insert/update at a time. Now with .NET they are really easy to implement so no more excuses. I’m busy right now sticking them in my webservice back end that has a variety of methods that do different multiple updates and inserts – so I really do need to have transactions. If I have to do 5 inserts and one of them craps out, I am going to be WAY better off in my client application if I can rollback the whole gaggle of records.
Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!