How to Transaction in ADO.NET
Performing a Transaction Using ADO.NET
A transaction consists of a single command or a group of commands that execute together. When we do some database operations in such a way that either all the database operations are successful or all of them fail. This would result in the amount of information being same once the transaction is complete or it fails.
Transactions allow you to combine multiple operations into a single unit of work. If a failure occurs at one point in the transaction, all of the updates can be rolled back to their pre-transaction state. In ADO.NET, you can control transactions using the Connection and Transaction objects. You can initiate a local transaction using BeginTransaction statement.
Once you have begun a transaction, you can enlist a command in that transaction using the Transaction property of the Command object.
You can then use the Transaction object to commit or rollback modifications made at the data source based on the success or failure of the components of the transaction.
The following example shows how to perform a transaction in an ADO.Net programming.
C# Source Code
VB.Net Source Code
- What are the advantage of ADO.Net
- Differences between classic ADO and ADO.NET
- What are managed providers
- difference between Dataset and DataReader
- How to ADO.Net Connection Pooling
- What is ADO.Net Locking
- Difference between SqlCommand and SqlCommandBuilder
- Difference between Typed DataSets and UnTyped DataSets