What is a transaction in ADO.NET, and how do you manage it?

A transaction in ADO.NET is a sequence of database operations that are executed as a

single unit. If one operation fails, all previous operations are rolled back. You can manage

transactions using the SqlTransaction object.

Steps: