About. Net nested transaction

Connection. begintransaction ()

The transactions of this method cannot be nested.

Error: Message"Sqlconnection does not support parallel transactions. "String

You can use transactionscope:

Windows

Distributed Transaction Coordinator (Distributed Transaction Coordinator)

Service.

// Main. csusing system; using system. collections. generic; using system. LINQ; using system. text; using system. data. sqlclient; using system. transactions; namespace consoleapptesttrannest {class program {static void main (string [] ARGs) {try {using (transactionscope S = new transactionscope ()) {sqlconnection conn = new sqlconnection (@ "Data Source =. \ sql2008r2; database = test; user id = sa; Password = 123; integrate D SECURITY = no; "); Conn. open (); sqlcommand cmd = Conn. createcommand (); cmd. commandtext = "insert into AAAA values ('a1')"; cmd. executenonquery (); cmd. commandtext = "insert into AAAA values ('a1')"; cmd. executenonquery (); Conn. close (); subclass. operationsql (); S. complete () ;}} catch (system. exception e) {console. writeline (E. message);} console. writeline ("done"); console. readkey () ;}}// subclass. CSU Sing system; using system. collections. generic; using system. LINQ; using system. text; using system. data. sqlclient; using system. transactions; namespace consoleapptesttrannest {public class subclass {public static void operationsql () {try {using (transactionscope S = new transactionscope ()) {sqlconnection conn = new sqlconnection (@ "Data Source =. \ sql2008r2; database = test; user id = sa; Password = 123; integrat Ed SECURITY = no; "); If (conn. State! = System. data. connectionstate. open) Conn. open (); sqlcommand cmd = Conn. createcommand (); cmd. commandtext = "insert into AAAA values ('s1')"; cmd. executenonquery (); int I = 0, B = 1, C; C = B/I; cmd. commandtext = "insert into AAAA values ('s1')"; cmd. executenonquery (); Conn. close (); S. complete () ;}} catch (system. exception e) {console. writeline (E. stacktrace );}}}}