The simplest way to use transactions today with Microsoft SQL Server 2000, using .Net Framework 2.0, is as follows: static void Main(string[] args) { using (TransactionScope ts = new TransactionScope()) { SqlConnection sqlConnection = new SqlConnection("connectionString"); sqlConnection.Open(); SqlCommand...

A key feature that targets performance in System.Transactions is the Promotable Single Phase Enlistment. It allows a durable resource manager (RM) to host and "own" a transaction that can later be promoted to a distributed transaction (or MSDTC transaction) if necessary. This specific resource manager...