Transactions and Threads

[Roy Chastain]

Please don't lecture me on the fact that a transaction (BeginTransaction -> Commit) should not last so long that it would be
crossing thread boundaries.

The question is
If I properly protect a SqlConnection object so that only 1 'action' (DataSet fill etc) is happening on it, can it (the
connection) and its associated transaction(s) be used by different threads?

 

[bruce barker]

yes.

-- bruce (sqlwork.com)

Please don't lecture me on the fact that a transaction

(BeginTransaction -> Commit) should not last so long that it would be

crossing thread boundaries.

The question is
If I properly protect a SqlConnection object so that only 1 'action'

(DataSet fill etc) is happening on it, can it (the

 

[Miha Markic [MVP C#]]

Second opinion: Yes
And, transactions shouldn't last long

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Please don't lecture me on the fact that a transaction

(BeginTransaction -> Commit) should not last so long that it would be

crossing thread boundaries.

The question is
If I properly protect a SqlConnection object so that only 1 'action'

(DataSet fill etc) is happening on it, can it (the