.net core使用SqlBulkLoader往Mysql数据库批量导入数据

首先添加引用 Mysql.Data

        /// <summary>
        /// Mysql 数据批量导入数据库  2020年4月30日12:55:16  Dennyhui
        /// </summary>
        /// <param name="_mySqlConnection">mysql连接字符串</param>
        /// <param name="Columns">表头</param>
        /// <param name="stream">数据流</param>
        /// <returns></returns>
        public int MysqlBulkLoad(MySqlConnection _mySqlConnection, List<string> Columns, Stream stream,string TableName)
        {
            MySqlBulkLoader bulk = new MySqlBulkLoader(_mySqlConnection)
            {
                CharacterSet = "UTF8",//防止中文乱码
                FieldTerminator = ",",
                FieldQuotationCharacter = '"',
                EscapeCharacter = '"',
                LineTerminator = "\r\n",
                //FileName = table.TableName + ".csv",
                SourceStream = stream,
                NumberOfLinesToSkip = 0,
                TableName = TableName,
                Local = true
            };
            bulk.Columns.AddRange(Columns);
            return bulk.Load();
        }