How can we perform transactions in .NET?
The common sequence of steps that would be performed for developing a transactional application is as follows:
1)In the first step open a database connection by using the Open method of the connection object.
2)In the second begin a transaction by using the Begin Transaction method of the connection object. This method gives us with a transaction object that we will use later to commit or rollback the transaction. Keep in mind that changes caused by any queries executed before calling the Begin Transaction method will be committed to the database immediately after they execute. Now Set the Transaction property of the command object to the above mentioned transaction object.
3)In the third step execute the SQL commands by using the command object. We can use one or more command objects for this purpose, as long as the Transaction property of all the objects is set to a valid transaction object.
4)In the fourth step roll back or commit the transaction by using the Commit or Rollback method of the transaction object.
5)At last close the database connection.