I recently upgraded an Entity Framework app from VS2015 to VS2017.
I have installed Oracle Developer Tools for VS 2017 v12.2.1100.
VS version is: Visual Studio Professional 2017 15.6.6
with:
EntityFramework v6.2.0
Oracle.ManagedDataAccess v12.2.1100
Oracle.ManagedDataAccess.EntityFramework v12.2.1100
Database version: 12.1.0.2.0
Also, Oracle ODAC v.11.2.0.1.0
is installed. - I have uninstalled this.
The problem is that when I run the program I often get
System.Data.Entity.Core.EntityException: 'The underlying provider failed on Open.'
InnerException: OracleException: Connection request timed out
at the first query in my program:
int operIDToUse = (from o in model.OPERINFOes
where o.OSUSER.ToUpper() == System.Environment.UserName.ToUpper() && o.IS_ACTIVE == true
select o.OPERID).SingleOrDefault();
I haven't seen the exception when the app is deployed. Also, it seems to go away if I restart the development pc, but then it comes again after rebuilding. It seems to be connected with the
following Intellisense error:
Error 175: The ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client' is either not registered in the machine or application config file, or could not be loaded. See the inner exception for details. MasterData C:\SS\C#\MasterData\MasterData\OFDModel.edmx
This error appears in the list the first time I build the project after having restarted the pc.
Since it is not a build error, it does not prevent the program from starting, but the above OracleException gets thrown when I run the program.