Nice System.Transactions article
If you are doing any sort of database updates you are more than likely using transactions. If you are not either your application is very simple or it’s a problem waiting to happen :-(
In .NET 2.0 the new System.Transactions and in particular the TransactionScope type make working with transactions a lot easier than before. In fact so easy that there really is no excuse not to use them. John Papa just published an interesting article in the MSDN magazine showing how and when to use the TransactionScope. Read the article at http://msdn.microsoft.com/msdnmag/issues/06/11/DataPoints/default.aspx
And just in case you where thinking I don’t do databases so I don't need TransactionScope it works with all sorts of resource managers. For example reading messages from a transactional MSMQ message queue can be wrapped in TransactionScope just fine.