How to add Oracle provider in VS2017 for Entity Framework?

Question

I want to connect to a database(Oracle 12c) for generating ADO.NET model, Code First From Database. I have installed ODAC for VS but there is still no option for connecting Oracle DB at the Entity Data Model Wizard:

At Server Explorer there is a Oracle provider but it is stated as deprecated:

I've also tried to install the following 4 Nuget packages but still no Oracle provider at Entity Data Model Wizard:

I'm suspecting VS2017(Community) is not looking at where I installed ODAC for the list of providers it use but I can't figure where it store this configuration.

Is there anything I'm missing? Or is there other ways to use EF for Oracle? E.g. Fallback to VS2015, create entity models manually (how do I do that?), etc.

Please help me I don't want to write plain SQL in code ever again! Thanks.

Answer 1

I have the same error. I solve this problem by add Oracle database from Visual 2015. And then Open project by Visual 2017. It done. I has been read a lot of topic about this. They say now, Oracle not yet Support for connecting Oracle DB at the Entity Data Model Wizard you can see at here: https://community.oracle.com/thread/4024914

Answer 2

There is something extra:

• Nuget package manager suggests Oracle.ManagedDataAccess.EntityFramework 18.3.0

This won't work with the latest ODP. Nuget Package versions should match ODP versions:

• ODP 12.2.0.1.1
• Nuget Oracle.ManagedDataAccess.EntityFramework 12.2.1100

If not the Entity Data Model Wizard will crash without leaving any trace in the

C:\Users\YOURUSER\AppData\Roaming\Microsoft\VisualStudio

Answer 3

I solved this by installing Oracle Developer Tools for Visual Studio 2017