I'm a long time user of SQL Server + LLBL and have been tasked with creating an application with .Net EF 6 and Oracle.

I have installed the ODP.Net (I think?) but when I try to use the designer for Oracle ODP.Net I get:

Exception message:

Exception type: ArgumentException Unable to find the requested .Net Framework Data Provider. It may not be installed.

***Installation of ODP.Net ***

` PS C:\oracle> .\install_odpm.bat c:\oracle x64

reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\Oracle Data Provider for .NET, Managed Driver" /v EventMessageFile /t REG_EXPAND_SZ /d C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\EventLogMessages.dll /f The operation completed successfully.

reg query HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319\AssemblyFoldersEx\odp.net.managed\

reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319\AssemblyFoldersEx\Oracle.ManagedDataAccess" /ve /t REG_SZ /d c:\Oracle\odp.net\managed\x64..\common /f The operation completed successfully.

reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319\AssemblyFoldersEx\Oracle.ManagedDataAccess.EntityFramework6" /ve /t REG_SZ /d c:\Oracle\odp.net\managed\x64..\common\EF6 /f The operation completed successfully. PS C:\oracle>

`

Fixed.

Step 1: Download the 64Bit ODAC XCopy from https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html

Step 2: Unzip to c:\oracle

Step 3: I needed to run this install:

C:\oracle> .\install_odpm.bat c:\oracle x64 true

Then reboot

Then it worked