Should I be using BeginTransaction over calling the SQL code directly as a command "BEGIN TRANSACTION"? When I've been searching for the answer to my next question all the examples used BeginTransaction. Is there any difference and advantage with one over the other?
Asked
Active
Viewed 123 times
0
noelicus
- 14,468
- 3
- 92
- 111
-
1We might need to see some actual code samples, especially for your last mentioned situation. – Damien_The_Unbeliever Oct 21 '13 at 10:12
-
Actually when I write a test the second problem goes away. More investigation required on that one. – noelicus Oct 21 '13 at 10:43
-
Have put it in another question now I've repeated it: http://stackoverflow.com/questions/19492943/is-this-transaction-being-rollbacked-for-me – noelicus Oct 21 '13 at 11:12
-
Why didn't you just edit this question? – Damien_The_Unbeliever Oct 21 '13 at 12:23
-
Initially I thought it was my mistake so edited it out - then when I saw it again and got some demo code showing it I thought it seemed like a good question in its own right. – noelicus Oct 21 '13 at 14:24