How to add Oracle provider in VS2017 for Entity Framework?

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


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


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