Transactions and transactionScope

[steve1rm]

Hello

VS 2005

I have been looking at transactions to rollback if 1 of my insert or updates does not complete successfully.

Code example:

dim ts as new transactionScope()

'Insert a record into table A
'Insert a record into table B 
'update table C
ts.Complete()

The above does not work too well with my code. I am wondering is there a better way to manage transactions.

Many thanks for any advice,

Steve

 

[jebenson]

What do you mean by 'does not work too well with my code'? Are you getting any error messages? What's the problem?



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira