Using Transactions
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL database in Microsoft Fabric
In SQL Server Management Objects (SMO), transaction processing is achieved through the connection to the instance of 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.