Better local transactions

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
 
M

Miha Markic

Hi Robert,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO.NET Transaction 10
Nested transactions with SQL connection object - how? 0
How to stop TransactionScope from starting distributed transaction 7
Distributed Transaction VS Local Transactions? 0
Contecting transactions between two stored procs 1
Transactions in ADO.NET or SQL SP 1
How to setup database to make transactions (transfers) between two bank accounts 0
Supporting Transactions A La System.Transactions in a custom system 2

Top