ExecuteMySqlBulkCopyAsync在.net core 3.1上 System.MissingMethodException : Method not found: 'System.Threading.Tasks.Task MySqlConnector.MySqlBulkCopy.WriteToServerAsync

[luoyunchong]

问题描述及重现步骤：

.net core 3.1 上使用 ExecuteMySqlBulkCopyAsync 会报如下错误。
.net 5.0 上运行正常。

 FreeSql.Tests.Provider.MySqlConnector.FreeSqlMySqlConnectorGlobalExtensionsTest.ExecuteMySqlBulkCopyAsync
   持续时间: 1.2 秒

  消息: 
    System.MissingMethodException : Method not found: 'System.Threading.Tasks.Task MySqlConnector.MySqlBulkCopy.WriteToServerAsync(System.Data.DataTable, System.Threading.CancellationToken)'.
  堆栈跟踪: 
    <<ExecuteMySqlBulkCopyAsync>b__0>d.MoveNext()
    AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine)
    <>c__DisplayClass1_0`1.<ExecuteMySqlBulkCopyAsync>b__0(MySqlBulkCopy bulkCopy)
    FreeSqlMySqlConnectorGlobalExtensions.ExecuteMySqlBulkCopyAsync[T](IInsert`1 that, Nullable`1 bulkCopyTimeout, CancellationToken cancellationToken) 行 114
    FreeSqlMySqlConnectorGlobalExtensionsTest.ExecuteMySqlBulkCopyAsync() 行 28
    --- End of stack trace from previous location where exception was thrown ---

 public class FreeSqlMySqlConnectorGlobalExtensionsTest
    {
        class BulkCopyValue
        {
            public Guid id { get; set; }
            public DateTime createtime { get; set; }
        }
        [Fact]
        public async Task ExecuteMySqlBulkCopyAsync()
        {
            var fsql = g.mysql;
            fsql.CodeFirst.SyncStructure<BulkCopyValue>();

            List<BulkCopyValue> bulkCopyValues = new List<BulkCopyValue>();
            for (var i = 0; i < 1000; i++)
            {
                bulkCopyValues.Add(new BulkCopyValue() { createtime = DateTime.Now });
            }
            await fsql.Insert<BulkCopyValue>().AppendData(bulkCopyValues).ExecuteMySqlBulkCopyAsync();
        }
    }

数据库的具体版本

mysql 5.7.34

安装的包

FreeSql.Provider.MySqlConnector 2.5.100

.net framework/. net core？ 及具体版本

. net core3.1

[luoyunchong]

支持

net45;net461;net471;netstandard1.3;netstandard2.0;netstandard2.1;netcoreapp2.1;netcoreapp3.1;net5.0

• https://github.com/mysql-net/MySqlConnector/blob/master/src/MySqlConnector/MySqlConnector.csproj

我这边测试，加上 netstandard2.1;netcoreapp2.1;netcoreapp3.1; 即可

[axinno1]

问题得到解决，谢谢叶老板