Better local transactions

  • Thread starter Thread starter Robert Scheer
  • Start date Start date
R

Robert Scheer

Hi.

Is there any guidelines for using local transactions? I mean, what is
the best approach for local transactions:

- Use the ado.net transaction object in client code?
- Create the transactions inside stored procedures?

Thanks,
Robert Scheer
 
Hi Robert,

I would with ado.net transactions - you have more control while having a
transaction within sp is slightly faster.
 
Back
Top