Web Form and ADO.NeT Transaction

[Lit]

Hi,

using ADO.NET 2.0, VS.NET 2005, SQL2005
I need to execute several Stored Procedures under one transaction. Can I
use just one command/transaction or have to use multiple ( then commit or
rollback all )
How does it work with ADO.NET

Ado.Tran
SP1 Called
loop
SP2 Called
SP3 Called
loop
SP4 Called
loop
Sp5 Called
Etc... etc...

if any error
rollback transaction ( or all transactions )
else
committe Transaction ( or all Transactions )

Thanks for any help or other Ideas, needs also code links etc..
Lit

[Lit]

Aidy,

you got a good point there. It is going to be a balancing game.
I will have to think about my domain of contexts ( small infinity ) and see
what would be best.

Thank you for the enlightenment.

Lit
"Aidy" <ai**@xxnoemail xx.comwrote in message
news:GM******** *************** *******@bt.com. ..

Yeah, but you'll need to clear out the old parameters collection. Maybe
you are using slightly less space, but you need to execute more commands.
Swings and roundabouts really.

"Lit" <sq**********@h otmail.comwrote in message
news:uF******** ******@TK2MSFTN GP02.phx.gbl...

>Aidy,

By reusing the Command Object I can reduce the number of objects in the
heap memory?

Thanks for your help.

Lit

"Aidy" <ai**@xxnoemail xx.comwrote in message
news:eu******* *************** ********@bt.com ...

>>Don't see what you can't re-use the same command object but I don't
think you'll particularly gain anything.

"Lit" <sq**********@h otmail.comwrote in message
news:eo****** ********@TK2MSF TNGP04.phx.gbl. ..
Aidy,
I have one question, but first thanks for the great link.

in Figure 8, I see the following code
...
oCmd1.Transacti on = oTran;
oCmd1.ExecuteNo nQuery();

oCmd2.Transacti on = oTran;
oCmd2.ExecuteNo nQuery();
...

Question is: Can I reuse the same command object? by setting the
command.Te xt to a different SP and Different Parameters instead of
creating different command objects.
would that work and is it more efficient.

Thanks again,

Lit
"Aidy" <ai**@xxnoemail xx.comwrote in message
news:l7***** *************** *@bt.com...
Have a look here
>
http://msdn.microsoft.com/msdnmag/is...DataPoints/#S6
>
"Lit" <sq**********@h otmail.comwrote in message
news:O0**** **********@TK2M SFTNGP04.phx.gb l...
>Hi,
>>
>using ADO.NET 2.0, VS.NET 2005, SQL2005
>I need to execute several Stored Procedures under one transaction.
>Can I
>use just one command/transaction or have to use multiple ( then
>commit or rollback all )
>How does it work with ADO.NET
>>
>Ado.Tran
> SP1 Called
> loop
> SP2 Called
> SP3 Called
> loop
> SP4 Called
> loop
> Sp5 Called
>Etc... etc...
>>
>if any error
> rollback transaction ( or all transactions )
>else
> committe Transaction ( or all Transactions )
>>
>Thanks for any help or other Ideas, needs also code links etc..
>>
>>
>Lit
>>
>>
>
>