Thanks. All is clear now :)
On 18/09/2007, Frans Bouma <[EMAIL PROTECTED]> wrote:
> > This is my first post in the mailing list but I read it all the time :)
> >
> > I have the following scenarion :
> >
> > Super stored proc :
> >
> > begin tran T1;
> > proc1;
> > proc2;
> > ...
> > commit
> This is my first post in the mailing list but I read it all the time :)
>
> I have the following scenarion :
>
> Super stored proc :
>
> begin tran T1;
> proc1;
> proc2;
> ...
> commit tran T1;
>
> I would like to call the procedure from ADO.NET but I want to finish
> some other work in C
I didn't quite follow your question; but it's not
necessary for an ADO.NET method to fail in order to use Rollback, any
method/code can fail to use Rollback (it doesn't even need to be an
exception...).
Your syntax just needs to be changed to use the SqlTransaction class:
SqlTransaction trans = d
Hi guys,
This is my first post in the mailing list but I read it all the time :)
I have the following scenarion :
Super stored proc :
begin tran T1;
proc1;
proc2;
...
commit tran T1;
I would like to call the procedure from ADO.NET but I want to finish
some other work in C# code before
