sqlclient - 在 .Net Core 2.0 中使用 System.Data.SqlClient.dll 时出现版本冲突错误

Question

在 .Net Core 2.0 中使用 System.Data.SqlClient.dll 时出现版本冲突错误。它看起来像是 Core dll 和 NetStandard dll 之间的冲突。不知道为什么提到

"System.Data.SqlClient, Version=4.5.0.0

这是不存在的。

Web 应用程序调用业务库，业务库又调用 DAL。 DAL 正在使用
System.Data.SqlClient.dll。全部都在 .Net Core2.0 中。

你能帮忙吗？

这是错误。

1> There was a conflict between "System.Data.SqlClient, Version=4.2.0.2, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" and "System.Data.SqlClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a". 1> "System.Data.SqlClient, Version=4.2.0.2, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" was chosen because it was primary and "System.Data.SqlClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" was not. 1> References which depend on "System.Data.SqlClient, Version=4.2.0.2, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" [C:\Program Files\dotnet\sdk\NuGetFallbackFolder\system.data.sqlclient\4.4.3\ref\netstandard2.0\System.Data.SqlClient.dll]. 1> C:\Program Files\dotnet\sdk\NuGetFallbackFolder\system.data.sqlclient\4.4.3\ref\netstandard2.0\System.Data.SqlClient.dll 1> Project file item includes which caused reference "C:\Program Files\dotnet\sdk\NuGetFallbackFolder\system.data.sqlclient\4.4.3\ref\netstandard2.0\System.Data.SqlClient.dll". 1> C:\Program Files\dotnet\sdk\NuGetFallbackFolder\system.data.sqlclient\4.4.3\ref\netstandard2.0\System.Data.SqlClient.dll 1> References which depend on "System.Data.SqlClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" []. 1> D:\Projects.Net Core\Test Apps\Postsharp\SmartBank.Web\SmartBank.Core.Business\SmartBank.Core.Business\bin\Debug\netcoreapp2.0\SmartBank.Core.DAL.dll 1> Project file item includes which caused reference "D:\Projects.Net Core\Test Apps\Postsharp\SmartBank.Web\SmartBank.Core.Business\SmartBank.Core.Business\bin\Debug\netcoreapp2.0\SmartBank.Core.DAL.dll". 1> SmartBank.Core.Business 1> C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(2052,5): warning MSB3277: Found conflicts between different versions of "System.Data.SqlClient" that could not be resolved. These reference conflicts are listed in the build log when log verbosity is set to detailed.

Answer 1

我有同样的问题:ORM 库使用 System.Data.SqlClient.dll (版本 4.6.0)直接但 Microsoft.AspNetCore.App在 4.5.1 版中也可以传递地导入它。

我已将 ORM 库切换为使用与 Microsoft.AspNetCore.App 中的库相同的版本但我有点担心升级时会发生什么