Transactions in .NET 2.0
I was introduced yesterday to the new namespace in .NET 2.0 about Transactions. Transactions at the business layer (C# domain objects) without the use of COM+ Transactions. There are two kinds Light Weight that depends on the SQL Server 2005 (single connection), once more than one connections are used, the Light Weight Transaction Manager will be promoted to OleTX Transaction Manager which is internally based on COM+.
Check out this great article:
Introducing System.Transactions in the .NET Framework 2.0
HTH
Regards