Appendix B. Transactions in ADO.NET
ADO.NET has built-in support for transactions, and transactional support in ADO.NET can be roughly divided into two categories: transaction management and transaction participation. Transaction management application programming interfaces (APIs) give ADO.NET applications a mechanism to explicitly manage transaction demarcation boundaries. Transaction participation allows transaction-aware resources to be enlisted with a transaction managed by some other entity—such as an external Transaction Manager.
There are two main approaches to transaction management in enterprise applications:
Manual or explicit transaction management
Automatic or declarative transaction management
With manual transaction ...