ADO.net > Performing Transactions

PERFORMING TRANSACTIONS IN ADO.NET
• Database transactions are used to control data commitment to databases
• ADO.net has three basic commands for transactions
1. BeginTransaction
2. Commit
3. Rollback

STEPS INVOLVED IN PERFORMING A DATABASE TRANSACTION

1. Objects required: SqlConnection, SqlCommand, SqlTransaction

2. Initialize SqlConnection object passing it the connection string
SqlConnection connection = new SqlConnection(“connection_string”);

3. Open the connection
connection.Open();

4. Initialize the SqlCommand by calling CreateCommand method of SqlConnection object
SqlCommand command = connection.CreateCommand();

5. Initialize the SqlTransaction object by calling BeginTransaction method of SqlConnection object
SqlTransaction transaction; transaction = connection.BeginTransaction(“transaction”);

6. Assign Connection and Transaction object to command object’s properties
command.Connection = connection; command.Transaction = transaction;

7. Assign Sql query string to CommandText property of SqlConnection object
connection.CommandText = “Insert into Region(col1,col2,col3) Values (c1Val,c2Val,c3Val)”;

8. Execute the query using SqlCommand object’s ExecuteNonQuery method
command.ExecuteNonQuery();

9. To commit the transaction, call Commit method of SqlTransaction object
transaction.Commit();

10. To rollback, call Rollback method of Transaction object
transaction.Rollback();