Your application involves updating records across different databases. How would you implement distributed transaction management in ADO.NET?

  • Data Reader
  • OleDbConnection
  • SqlCommand
  • TransactionScope
Distributed transaction management in ADO.NET can be implemented using TransactionScope. TransactionScope provides a simple and efficient way to manage distributed transactions across multiple databases or resource managers. It automatically handles enlisting connections in the transaction and ensures that either all operations across different databases succeed or fail together, maintaining data integrity and consistency.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *