Using Transactions
In SQL Server Management Objects (SMO), transaction processing is achieved through the connection to the instance of Microsoft SQL Server by using the ServerConnection object. The ServerConnection object is referenced by the ConnectionContext property of the Server object when the connection is established. Methods such as StartTransaction, RollBackTransaction, and CommitTransaction belong to the ConnectionContext object property.