I recently had some problems with using TransactionScope and here are some related articles I found.
Unwanted promotion using TransactionScope on MSDN Social
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/3ce488eb-55a8-4535-adc7-c5b29a1523b5/
System.Transactions LTM "limitation" by @kjellsj
http://kjellsj.blogspot.com/2005/11/systemtransactions-ltm-limitation.html
System.Transactions LTM - promoting to DTC by @kjellsj
http://kjellsj.blogspot.com/2006/01/systemtransactions-ltm-promoting-to.html
System.Transactions - Nesting Scopes, Enlist Connection in Transaction by @kjellsj
http://kjellsj.blogspot.com/2006/04/systemtransactions-nesting-scopes.html
A few System.Transactions gotchas by @kjellsj
http://kjellsj.blogspot.com/2009/01/few-systemtransactions-gotchas.html
System.Transactions namespace on MSDN
http://msdn.microsoft.com/en-us/library/system.transactions.aspx
ADO.NET and System.Transactions by John Papa
http://msdn.microsoft.com/en-us/magazine/cc163847.aspx
How do i enable MSTDC on sqlserver? on StackOverflow
http://stackoverflow.com/questions/7694/how-do-i-enable-mstdc-on-sqlserver
A ConnectionScope class. MS Data Access blog
http://blogs.msdn.com/b/dataaccess/archive/2006/02/14/532026.aspx
Lightweight Promotable Transactions, SqlDataReader and Commitment. MS Data Access Blog
http://blogs.msdn.com/b/dataaccess/archive/2006/04/14/576669.aspx
Whidbey ADO.NET Promotable Transactions with System.Transactions & Yukon - Angel Saenz-Badillos
http://blogs.msdn.com/b/dataaccess/archive/2006/04/14/576669.aspx





