topic Re: ArcGIS Pro SDK for .Net loading dlls and app.config settings in ArcGIS Pro SDK Questions

ArcGIS Pro SDK for .Net loading dlls and app.config settings

CARNELL_DEVTWO — Wed, 08 Jul 2020 15:54:17 GMT

I am trying to use some third party dlls (Entity Framework and EntityFramework.SqlServer) in my arcgis Pro sdk module. However, whenever my code runs inside ArcMap pro, I get errors like this:

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0'. Make sure the provider is registered in the 'entityFramework' section of the application config file.

I have several stand alone apps with exactly the same app.config file "entityFramework" section which all work fine:

<entityFramework>
   <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices,       EntityFramework.SqlServer" />
      <provider invariantName="System.Data.SqlServerCe.4.0"       type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact" />
   </providers>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
   <parameters>
   <parameter value="System.Data.SqlServerCe.4.0" />
   </parameters>
</defaultConnectionFactory>
</entityFramework>

During debug, I can see that the modules have loaded. In my program output I get messages like this:

C:\Users<username>\AppData\Local\ESRI\ArcGISPro\AssemblyCache{05b82a89-759c-4123-b178-75b72b968646}\EntityFramework.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'ArcGISPro.exe' (CLR v4.0.30319: ArcGISPro.exe): Loaded 'C:\Users<username>\AppData\Local\ESRI\ArcGISPro\AssemblyCache{05b82a89-759c-4123-b178-75b72b968646}\EntityFramework.SqlServer.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'ArcGISPro.exe' (CLR v4.0.30319: ArcGISPro.exe): Loaded 'Anonymously Hosted DynamicMethods Assembly'.
Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Data.SqlServerCe\4.0.0.0__89845dcd8080cc91\System.Data.SqlServerCe.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

I wonder if anyone else has had a similar problem, if there is some reference or app.config setting I am missing. Or if ArcGIS pro sdk for .Net doesn't read the app.config?

Re: ArcGIS Pro SDK for .Net loading dlls and app.config settings

DHuantes — Thu, 09 Jul 2020 13:25:11 GMT

One important thing that I've learned with .Net Add-In development is that the SDK builds a <NameOfYourAddIn>.esriAddInX archive in your My Documents/ArcGIS/AddIns/ArcGISPro/{GUID_FOR_YOUR_ADDIN} folder. This is a compressed file and if you extract it's contents with 7Zip you'll see everything the SDK deemed necessary for your AddIn. With respect to assemblies, those will all be in the "Install" folder. When ArcGIS Pro launches part of it's startup process is to check for Addins in the My Documents/ArcGIS/AddIns/ArcGISPro folder. For each one it finds, with respect to AddIns, it take everything that's in the "Installs" folder and copies it to the user's App Data/Local/ESRI/ArcGISPro/AssemblyCache. So based on your warnings this seems to all be correct. If you had Native DLL's (i.e. C++ DLLs) dependencies, you are on your own (as I am) but that is not your issue.

Here is more extensive explanation of the same process....ProConcepts Advanced Topics · Esri/arcgis-pro-sdk Wiki · GitHub

But again I don't think that is your problem based on the warnings... BTW those warnings are just saying you won't be able to debug into those System assemblies.

Found this on Stack Overflow..... I'm thinking this is your problem....

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient' - Stack Overflow

Re: ArcGIS Pro SDK for .Net loading dlls and app.config settings

CARNELL_DEVTWO — Thu, 09 Jul 2020 13:49:59 GMT

Thanks for your reply,

I've been poking around in these folders a bit myself. The DLLs that I need all seem to be in the App Data/Local/ESRI/ArcGISPro/AssemblyCache folder.

I really can't figure out why some packages work just fine but others don't. The only difference I can think of is that the one that doesn't work is dependent on info in the app.config file, but I don't see why that would be the problem.

With regards to that stack overflow thread, I have added these references in both projects in the solution.

Re: ArcGIS Pro SDK for .Net loading dlls and app.config settings

DHuantes — Wed, 29 Jul 2020 11:45:33 GMT

Did you get it working?

I was looking for an old question I posted and saw this again....

Figured I'd try another search.... If you have not resolved your issue maybe this thread will help...

Use an app.config file with an ArcGIS Pro Add-In

Re: ArcGIS Pro SDK for .Net loading dlls and app.config settings

CARNELL_DEVTWO — Fri, 31 Jul 2020 10:37:28 GMT

Hi Daniel,

Thank you for following up. I actually used a workaround by piping the data to a child process totally independent of the ArcGIS Pro module! Obviously not an ideal solution.

That link does look very hopeful and much cleaner, I will try it out and let you know.

Re: ArcGIS Pro SDK for .Net loading dlls and app.config settings

usravank1898 — Thu, 08 Dec 2022 21:22:11 GMT

app.config is still an issue.

I have created the wpf .net 6 application with 3rd party dll's and these dlls read connection string information from the app.config file. This project works just fine if I reference this project in the different, NET 6 WPF project everything works fine. But if we reference it to ArcGIS Pro visual studio project Templates, AddIn can't recognize the connection string information from app.config file.

I tried copying app.config file into ArcGIS Pro bin file still not picked up by the AddIn.

Thanks,