How to connect oracle 12 c with entitiy framework v.5.0 - visual studio 2017

1) install oracle 12 c 12.1.0.2.0(http://www.oracle.com/technetwork/database/enterprise edition/downloads/database12c-win64-download-2297732.html)

2) if you have dr0ulib.sql.sbs error when install oracle 12 c

•  Abort the current installer


• Open the winx64_12c_database_2of2 directory and navigate to ..\winx64_12c_database_2of2\database\stage\Components directory copy all the files


• Paste all files to the following location..\winx64_12c_database_1of2\database\stage\Components

 

• Now run the setup.exe “Run as administrator” and follow the instructions to complete the installation without error.

3) install ( 64-bit ODAC 12c Release 1 (12.1.0.1.0) for Windows x64) http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html - VS 2017

http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownload-2745497.html - VS2015

4)Open visual studio

5)İnstall Entitiy Framework 5.0 on nuget

6)Project Right Click > Add > New Item > Data > ADO.NET Enitity Data Model>  > EF Desiger From database > New Connection > You must fill the area (Username,Password) you check connect as sysdba role and then select the connection type (im using ez connect ) database host name 127.0.0.1, port number 1521 , database service name orcl  (you have to grant sysdba database user GRANT SYSDBA to BURAK;)

7) if you have error 'Unable to find the requested .Net Framework Data Provider. It may not be installed'

8) İnstall Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntitiyFramework on nuget.