Several weeks ago, I installed the Oracle developer tools for Visual Studio 2017. Configured the tnsnames.ora file. I then wrote code to access tables using the Oracle managed data provider, no issues. Next used Entity Framework to access tables via “EF Designer from existing database” rather than the alternates e.g. code first as this is simply tinkering at the present time and have years’ experience writing code with EF using SQL-Server. I was able to read/update/insert no problem.
Afterwards at some point (I’m sure it was something I did in the project code or config file) I did a build at got
Error 175: The ADO.NET provider with invariant name 'Oracle.DataAccess.Client' is either not registered in the machine or application config file, or could not be loaded. See the inner exception for details Model1.edmx 8
Seemed prudent to uninstall/install all the Oracle software from the Oracle Developer Tools for Visual Studio. Fired up Visual Studio, received the exact same error message.
I tried the solution here but no different https://www.codeproject.com/Tips/524041/Entity-Framework-ProviderManifestToken-not-valid
In a fresh project, attempted to add a model but the Oracle provider does now show anymore.
I have searched the web and most seem to resolve this issue with an uninstall/install yet this failed for me.
Checked machine.config location C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\
<section name="system.data.oledb" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<section name="system.data.oracleclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
So I’m looking for advice on the above issue. Worst case is I forget about Oracle/EF and go old school with the managed data provider.