C# 批量插入Mysql
string connectString = "server=localhost;user=root;database=dbtest;port=3306;password=;charset=utf8";
public static void batchSql(List list)
{
List sqlList = new List();
List paraList = new List();
foreach (DataObj oh in list)
{
MySqlParameter[] parameters = new MySqlParameter[19];
parameters[0] = new MySqlParameter("@param1", MySqlDbType.VarChar, 50);
parameters[0].Value = oh.param1;
parameters[1] = new MySqlParameter("@param2", MySqlDbType.VarChar, 50);
parameters[1].Value = oh.param2;
sqlList.Add(sqlInsert);
paraList.Add(parameters);
}
ExecuteTransaction(sqlList, paraList);
}
/**
* 执行事务
* */
public static void ExecuteTransaction(List sqlList, List