using ADO.NET 2.0, VS.NET 2005, SQL2005
I need to execute several Stored Procedures under one transaction. Can I
use just one 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 )
Re: Recordset.AddNew and the recordset objects data retaining ... You may be right about the transaction.... round trip per each loop.... with one database update trip PER RECORD is catastrophic. ... paging issues to keep the memory resources under control if you need better ... (microsoft.public.data.ado)
Re: Transactions - Infinite Loops ... This still doesn't sound like an infinite loop.... > It was an unusual SQL Server response that we were unable to duplicate. ... > transaction if the wrong number of felds are being updated (i.e., ... > the query ran okay. ... (microsoft.public.sqlserver.programming)
Re: rollback transaction not rolling back ...Mike...ROLLBACK TRANSACTION... If it finds an error in the loop I want it to ... (microsoft.public.sqlserver.programming)
Re: Transactions - Infinite Loops ... If you're really in a loop, you will not be able to enter any more commands. ... If you just forgot to commit, SQL Server cannot tell you that, as it has no ... of the same transaction....COMMIT TRAN.... (microsoft.public.sqlserver.programming)
Re: SqlDataReader performance ... so its best to get the ordinalbefore the loop begins. ... The query performes acceptable in the Query analyzer. ... As you can see most of the time is spendt getting data from the DataReader ... What effect has a transaction on this? ... (microsoft.public.dotnet.framework.adonet)
