C#中mysql批量添加数据

 public bool Save(List<test> list)
        {
   
       // 第一种：使用MySqlBulkLoader批量添加
        //DataTable dt = FillDataTable(list);
            //dt.TableName = "test";
            //var columns = dt.Columns.Cast<DataColumn>().Select(_columns => _columns.ColumnName).ToList();
            //string tmpPath = "F:\\UpTemp";
            //if (!Directory.Exists(tmpPath))
            //    Directory.CreateDirectory(tmpPath);
            //tmpPath = Path.Combine(tmpPath, "test.csv");//csv文件临时目录

            //string csv = DataTableToCsv(dt);
            //if (File.Exists(tmpPath))
            //    File.Delete(tmpPath);
            //File.WriteAllText(tmpPath, csv);
            //using (MySqlConnection conn = new MySqlConnection(connectionStr))
            //{
   
            //    conn.Open();
            //    MySqlBulkLoa