You are working on an application where data consistency is critical, and multiple database operations must succeed or fail together. Which ADO.NET feature should you use to achieve this?

  • Command Object
  • Connection Pooling
  • Data Adapter
  • Transactions
Transactions in ADO.NET allow you to group multiple database operations into a single unit of work. This ensures that either all operations succeed, committing the changes to the database, or all operations fail, rolling back any changes made. It helps maintain data consistency by enforcing atomicity, consistency, isolation, and durability (ACID properties) across multiple database operations.
Add your answer
Loading...

Leave a comment

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