代码看起来像这样;

sqlConnection cn1 = new sqlConnection();
cn1.Open(); //connection opened when there is no ambient transaction.
...

using(TransactionScope scope = new TransactionScope())
{
  sqlCommand cmd; //a typical sql command.

  ...

  cmd.ExecuteNonQuery(); //Is this command within transaction?
  ...
}

解决方法

• 上一篇：azure – 由于外键冲突无法恢复bac下一篇：sql-server – 如何在SQL Server 2