locked
How to Execute T-SQL Transactions in ADO.Net

    Question

  • Dear Friends,

    How to Execute T-SQL Transactions in ADO.Net. Can u xplain me with sample code

    Thursday, September 04, 2008 5:09 AM

Answers

  • Hi Emcube,


    According to MSDN, A transaction consists of a single command or a group of commands that execute as a package. 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.


    Here are some documents about the Transactions and the ADO.Net, some of them comprise samples about how to use Transaction in ADO.Net, and perhaps you can get some inspirations.

    Transactions and Concurrency (ADO.NET)

    Performing a Transaction Using ADO.NET

    Transaction Processing in ADO.NET 2.0


    Regards,

    Xun

    Monday, September 08, 2008 3:08 AM