topic Re: ArcGIS Pro 3.0 - System.Data.SqlClient.dll reference assembly in ArcGIS Pro SDK Questions

ArcGIS Pro 3.0 - System.Data.SqlClient.dll reference assembly

MadsHoumann — Thu, 08 Sep 2022 21:33:28 GMT

The ArcGIS Pro 3.0 install include System.Data.SqlClient.dll reference assembly.
As far as I can see, the actual implementation assemblies are not installed.

Our add-in needs System.Data.SqlClient, but since the ArcGIS Pro 3.0 installed version: 'C:\Program Files\ArcGIS\Pro\bin\System.Data.SqlClient.dll' is just the reference assembly it doesn't work.
And this version is loaded even when the correct implementation assembly is included in the add-in.

Am I missing something here? or is it a bug in the ArcGIS Pro 3.0 install?

Re: ArcGIS Pro 3.0 - System.Data.SqlClient.dll reference assembly

Wolf — Fri, 09 Sep 2022 14:56:33 GMT

You can look at this example (from community samples) which is using the Microsoft.Data.SqlClient NuGet in its plug-in project: ProSqlExpressReader solution more specifically the 'Microsoft.Data.SqlClient' package reference in this project: arcgis-pro-sdk-community-samples/ProSqlExpressDb.csproj at master · Esri/arcgis-pro-sdk-community-samples (github.com)

Also check here regarding SqlClient in .Net 6.0: Introducing the new Microsoft.Data.SqlClient - .NET Blog

Re: ArcGIS Pro 3.0 - System.Data.SqlClient.dll reference assembly

MadsHoumann — Fri, 09 Sep 2022 15:33:33 GMT

Thanks,
I guess switching to Microsoft.Data.SqlClient will be an OK option for us.

Re: ArcGIS Pro 3.0 - System.Data.SqlClient.dll reference assembly

RichardDaniels — Wed, 15 Feb 2023 20:24:31 GMT

The real question is WHY is System.Data.SqlClient.dll event included in the ArcGIS Pro 3.0 install package, and why is it located at C:\Program Files\ArcGIS\Pro\bin?

ArcGIS Pro is built on .Net Framework 6.0.5 which does not support the use of System.Data.SqlClient. All Add-ins should be rebuilt to use Microsoft.Data.SqlClient and WebView 2 (vs. WebBrowser).