SQL transaction

TransactionScope for SQL commands not working as expected? This article describes shortly how to use TransactionScope and also one of the most easy-to-make errors.