插入多条记录事务：避免拼串

来源：互联网发布：本草纲目辣妹子知乎编辑：程序博客网时间：2024/06/07 03:24

删除多条记录事务：

using (DbConnection conn = IDataAccess.CreateConnection)            {                conn.Open();                using (DbTransaction tran = conn.BeginTransaction())                {                    foreach (CompareTableInfo info in list)                    {                        SqlParameter[] parameters = { new SqlParameter("@db_code", SqlDbType.Int),                                             new SqlParameter("@t_name", SqlDbType.VarChar),                                             new SqlParameter("@original_count", SqlDbType.Int),                                            new SqlParameter("@real_time_count", SqlDbType.Int),                                            new SqlParameter("@diff_value", SqlDbType.Int)                                         };                        parameters[0].Value = info.DBCode;                        parameters[1].Value = info.TName;                        parameters[2].Value = info.OrignalDBRecordsCount;                        parameters[3].Value = info.RealTimeDBRecordsCount;                        parameters[4].Value = info.DiffValue;                        IDataAccess.ExecuteNonQuery(tran, CommandType.Text, sqlAddCompareInfo, parameters);                    }                    tran.Commit();                }                if (conn.State != ConnectionState.Closed)                {                    conn.Close();                }            }