C# 批量执行 sql语句 事务 参数

List<keyValue> SQLStringList = new List<keyValue>();

foreach (KeyValuePair<string, decimal> item in datas)
{
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.VarChar,10),
new SqlParameter("@name", SqlDbType.Decimal)
};
parameters[0].Value = item.Key;
parameters[1].Value = item.Value;

string strsql = " update product set name=@namewhere id=@id";
SQLStringList.Add(new keyValue(strsql, parameters));
}

DbHelperSQL.ExecuteSqlTran(SQLStringList);
}

转载于:https://www.cnblogs.com/xiguanjiandan/p/3564345.html