可收集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到任务程序的根目录即可。
最新文章
- PHP存储blob示例（转）
- SpringMVC源码分析系列
- easyUI笔记09.03
- Unity-WIKI 之 AllocationStats(内存分配)
- [BZOJ1998][Hnoi2010]Fsk物品调度
- 【VB6笔记-02】从Command中获取链接参数
- 使用WBI SAP Adapter 实现IDoc的同步处理（转）
- boot/head.S
- zoj 3778 Talented Chef(思维题)
- java下的第一个redis
- Linux PCI网卡驱动的详细分析
- 马云收购UC你，至于到底是谁宣战
- js原生设计模式——2面向对象编程之继承—多继承
- 浅谈java类集框架和数据结构(2)
- 讲述Sagit.Framework解决：双向引用导致的IOS内存泄漏（下）- block中任性用self
- Java中对List去重, Stream去重
- teachable-machine:探索机器学习如何工作，浏览器中实时浏览
- 系统磁盘优化——"/var/spool/postfix/maildrop"
- JVM（二）垃圾回收
- canvas（一） 基本线条绘制