Great news! The new updates added to System.Data and SQL Server 2008 finally allow multiple Open/Close connections to the same SQL Server without promoting the transaction to MSDTC.
This was by far the most requested feature for the System.Transactions/System.Data/SQL Server combination.
There is no more the need to write workarounds like ConnectionScope to avoid promotions.
Now I can write as many Open/Close, Open/Close as I need to, without worrying about promotion:
using (SqlConnection connection1 = new SqlConnection(connectionString))
SqlCommand command1 = new SqlCommand(commandString1, connection1);
SqlCommand command2 = new SqlCommand(commandString2, connection1);
using (SqlConnection connection2 = new SqlConnection(connectionString))
SqlCommand command1 = new SqlCommand(commandString1, connection2);
SqlCommand command2 = new SqlCommand(commandString2, connection2);
More details on the updates at the ADO.Net team blog.