How can we perform transactions in .NET?

Answer

Following are the general steps that are followed during a transaction:

• Open connection
• Begin Transaction: the begin transaction method provides with a connection object this can be used to commit or rollback.
• Execute the SQL commands
• Commit or roll back
• Close the database connection