I am already using Enterprise Service Transactions in an app that I wrote to automate the generation of invoices at Walsh.

This same technique is an option (I have probably blogged about it before, but this is a nice article) for rolling back DB changes.

http://weblogs.asp.net/rosherove/articles/dbunittesting.aspx