Where do you put your transaction code?
-
Hey guys. A little question on transaction best practices: 1. Where do you put your transaction control code? I mean: Do you put it in the code (try catch rollback()), or do you put it in the stored procedure? 2. Do you use transactions for simple insert, delete, update sentences? Best Regards Soeren
-
Hey guys. A little question on transaction best practices: 1. Where do you put your transaction control code? I mean: Do you put it in the code (try catch rollback()), or do you put it in the stored procedure? 2. Do you use transactions for simple insert, delete, update sentences? Best Regards Soeren
Bad Robot wrote:
1. Where do you put your transaction control code? I mean: Do you put it in the code (try catch rollback()), or do you put it in the stored procedure?
Stored Procedure usually, but sometimes I'll need to do several things in sequence so I'll managet the transaction in .NET
Bad Robot wrote:
2. Do you use transactions for simple insert, delete, update sentences?
If it is a simple oneliner then no because SQL Server, by default, will automatically put that in a transaction for me.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog