Check if a connection is in a transaction

Posted by acidzombie24 on Stack Overflow See other posts from Stack Overflow or by acidzombie24
Published on 2010-05-18T09:36:53Z Indexed on 2010/05/18 9:40 UTC
Read the original article Hit count: 137

Filed under:
|

I am getting a SqlConnection does not support parallel transactions. exception and this answer mentions its when a connection tries to open two transactions. This is exactly what i am doing. I thought nested transactions were ok (i was using sqlite for the prototype).

How do i check if the connection is already in a transaction? I am using Microsoft SQL Server Database File.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server