C#事务处理疑问
List<string> sqlList= new List<string>(); sqlList.Add("update pictures set remark='testb' where infouuid='test'"); sqlList.Add("update pictures set remarkf='testb' where infouuid='test0'"); sqlList.Add("update pictures set remark='testb' where infouuid='test2'"); using (DbConnection connection = GetConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); DbCommand cmd = connection.CreateCommand(); cmd.Transaction = transaction; foreach (string strSql in sqlList) { if (!string.IsNullOrEmpty(strSql)) { cmd.CommandText = strSql; cmd.ExecuteNonQuery(); } } transaction.Commit(); }