/SQL/C# sql transaction multiple connections

C# sql transaction multiple connections

using(System.Transaction.TransactionScope myScope = new TransactionScope()){
  //all of your sql connections and work in here

  //call this to commit, else everything will rollback
  myScope.Complete();
}

Source: stackoverflow.com

Similar codes

1 vote143 views1 answer
Sql server list locks
SQL
0 vote140 views1 answer
Sum value by month sql
SQL
0 vote125 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote144 views1 answer
Rename constraint postgresql
SQL
-1 vote142 views1 answer
Can pandas fetch data from sql
SQL
0 vote142 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote145 views2 answers
How to update the multiple rows in sql
SQL
0 vote148 views1 answer
Count characters of string mysql
SQL
-1 vote132 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
-1 vote141 views1 answer
Get id from just inserted row mysql server python
SQL