Good read which explains updates to SqlClient's System.Transactions in SQL Server 2008 which results in more light-weight transactions by reducing the 'auto-promotion' behavior

ADO.NET team blog : Extending Lightweight Transactions in SqlClient