forum

home / developersection / forums / ado.net transaction when command's transaction is not set

Ask Question

ADO.Net Transaction when Command's transaction is not set

Anonymous User 2980 19-Jun-2013
Hi Expert, 

I came across a sample on ADO.Net, where a transaction was being done without setting the command's transaction property as in code below.

Is this possible Or one needs to explicitly set the command's transaction property?

// Start a local transaction.
SqlTransaction sqlTran = connection.BeginTransaction();

// Enlist a command in the current transaction.
 SqlCommand command = connection.CreateCommand();
-----
-----
sqlTran.Commit()

Any help on above is really appreciated.
ado.net ado.net 
Updated on 19-Jun-2013
Anonymous User

Other

I am a content writter !

Follow
Can you answer this question?
Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

19-Jun-2013
Hi Tanuj,

That should throw a runtime exception. That is, if you have an active transaction on a SqlConnection and do not assign a reference to the corresponding SqlTransaction to the SqlCommand.Transaction property and attempt to execute the command, you should get an exception.

In short, set the Transaction property explicitly when executing a command on a connection with an active transaction.

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy