I've seen from previous issues there was an issue with ClickOnce not deploying the Microsoft.Data.SqlClient.SNI dll, however this was apparently fixed in version 2.0.
It appears this issue still persists with VSTO Addins.
To reproduce
Create a new Outlook VSTO add-in in VS - File > New > Project > Outlook VSTO Add-in
Install Microsoft.Data.SqlClient NuGet package, version 2.0.1, Microsoft.Data.SqlClient.SNI 2.0.1 is installed as a dependency
Publish using ClickOnce (Properties > Publish > Publish Now)
Expected behaviour
Microsoft.Data.SqlClient.SNI.x86/x64.dll.deploy should be copied to the "Application Files" directory.
Further technical details
Microsoft.Data.SqlClient version: 2.0.1
.NET target: Framework 4.8
SQL Server version: SQL Server 2019
Operating system: Windows 10
Outlook: Office 356
Describe the bug
I've seen from previous issues there was an issue with ClickOnce not deploying the Microsoft.Data.SqlClient.SNI dll, however this was apparently fixed in version 2.0. It appears this issue still persists with VSTO Addins.
To reproduce
Create a new Outlook VSTO add-in in VS - File > New > Project > Outlook VSTO Add-in Install Microsoft.Data.SqlClient NuGet package, version 2.0.1, Microsoft.Data.SqlClient.SNI 2.0.1 is installed as a dependency Publish using ClickOnce (Properties > Publish > Publish Now)
Expected behaviour
Microsoft.Data.SqlClient.SNI.x86/x64.dll.deploy should be copied to the "Application Files" directory.
Further technical details
Microsoft.Data.SqlClient version: 2.0.1 .NET target: Framework 4.8 SQL Server version: SQL Server 2019 Operating system: Windows 10 Outlook: Office 356