可收集ALC问题[Microsoft.Data.SqlClient is not supported on this platform.]

异常

Microsoft.Data.SqlClient is not supported on this platform.

堆栈跟踪

    at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)

    at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()

    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()

    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.<OpenAsync>d__47.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.<BeginTransactionAsync>d__38.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.<BeginTransactionAsync>d__36.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.<ExecuteAsync>d__8.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.<ExecuteAsync>d__8.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<SaveChangesAsync>d__97.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<SaveChangesAsync>d__101.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__7`2.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at Microsoft.EntityFrameworkCore.DbContext.<SaveChangesAsync>d__54.MoveNext()

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

    at TM.Framework.Repository.EFCore.Repository`2.<InsertAsync>d__15.MoveNext() in F:\Personal\Project\Git\Repos\WM\TM.Framework.Repository\DbCore\EFCore\Repository.cs:line 51

    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

    at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()

 

 

任务调度创建可收集ACL后，加载任务程序集运行时，执行EF时报异常，且明确指出Microsoft.Data.SqlClient程序集不支持该平台，经测试.Net Core 3.1的网站(aspnet core)和控制台程序，在运行时会自动选用runtime文件夹下的对应dll，即AssemblyLoadContext.Default中加载的分别为：

 

文件名称：（asp.net core）

\bin\Release\netcoreapp3.1\runtimes\win\lib\netcoreapp2.1\Microsoft.Data.SqlClient.dll

文件大小：1227736 字节

文件版本：1.0.19269.1

修改时间：2019年9月26日 20:43:26

MD5     ：0FE582BD41A492D8D583E60AB559EC93

SHA1    ：A935CAE85E421960A617FDFAA57738E2A0ACEEF9

CRC32   ：A7500F80

 

文件名称：(.net core console)

\bin\Debug\netcoreapp3.1\runtimes\win\lib\netcoreapp2.1\Microsoft.Data.SqlClient.dll

文件大小：1227736 字节

文件版本：1.0.19269.1

修改时间：2019年9月26日 20:43:26

MD5     ：0FE582BD41A492D8D583E60AB559EC93

SHA1    ：A935CAE85E421960A617FDFAA57738E2A0ACEEF9

CRC32   ：A7500F80

 

由于任务调度程序加载dll时是从运行目录中寻找并不会查看runtime文件夹，因此导致当前目录里的同名dll被加载，因此抛出开头的异常。

 

文件名称：(运行目录)

\bin\Debug\netcoreapp3.1\Microsoft.Data.SqlClient.dll

文件大小：330712 字节(偏小)

文件版本：1.0.19269.1

修改时间：2019年9月26日 20:43:28

MD5     ：5715D2FA9EDF8C80D8B1209F9C7D3624

SHA1    ：993D17482A5ED75CC78E4E6302934DA0D24DAE0D

CRC32   ：FC165A30

 

总结：

复制\bin\Debug\netcoreapp3.1\runtimes\win\lib\netcoreapp2.1\Microsoft.Data.SqlClient.dll里的dll到任务程序的根目录即可。