mysql bulk insert_MySql 使用MySqlBulkLoader批量插入

#region 批量插入数据

/

/ 批量插入收集库件级文书档案信息实体(批量)/

/数据表

/

public intBulkInsert(DataTable table)

{int insertCount = 0;try{

table.TableName= "tb_jj_ws_collect";//数据库中的表名

string connectionString =db.Database.Connection.ConnectionString;if (string.IsNullOrEmpty(table.TableName)) throw new Exception("请给DataTable的TableName属性附上表名称");if (table.Rows.Count == 0) return 0;string tmpPath = Directory.GetCurrentDirectory() + "\\UpTemp";if (!Directory.Exists(tmpPath))

Directory.CreateDirectory(tmpPath);

tmpPath= Path.Combine(tmpPath, "Temp.csv");//csv文件临时目录

string csv =DataTableToCsv(table);

File.WriteAllText(tmpPath, csv);var columns = table.Columns.Cast().Select(_columns =>_columns.ColumnName).ToList();using (MySqlConnection conn = newMySqlConnection(connectionString))