Using SqlTransaction with SqlCommandType = StoredProcedure

[teixeira]

Hello,

 

Is it possible to make an SqlTransaction having a strored procedure as my sqlcommandtext ?

 

In the examples i've seen people just use transactions with sqlcommandtext containing UPDATE, DELETE or INSERT code.

 

Is it possible?

 

TIA,

[PlausiblyDamp]

There is no reason at all why you can't use a stored proc as part of a SqlTransaction.

 

The only thing you might need to be careful about is if the stored proc itself also begins it's own transactions.

[teixeira]

Hi,

 

It starst its own transactions, but if we specify that syntax inside the procedure use T-SQL "Transaction" reserved word, right? or it starts an implicit transaction in any SP we create even we don't use explicitly declare de T-SQL "Transaction" reserved word?

 

Best regards,

Tiago Teixeira