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

Question

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: During debug, I can see that the modules have loaded. In my program output I get messages like this: C:\Users\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\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?

usravank1898 · Answer

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,

S

CARNELL_DEVTWO · Answer

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.

DanielHuantes · Answer

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