/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

0 vote163 views1 answer
Mysql_union
SQL
1 vote177 views1 answer
Second last highest id in sql
SQL
0 vote208 views3 answers
Select top 10 rows in sql
SQL
0 vote181 views1 answer
Ignore case in string sql
SQL
-1 vote170 views1 answer
Mysql case when multiple conditions
SQL
0 vote201 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote167 views1 answer
Sql count total by foreign key
SQL
0 vote177 views1 answer
Search from comma separated values in sql server
SQL
0 vote168 views1 answer
Get who is hired in specific month in sql
SQL
17 votes179 views6 answers
Get last record in sql
SQL