visual studio 2015: setup EF6 with oracle

c# entity-framework-6 oracle visual-studio-2015

Question

I am trying to create Entity framework 6 model for an Oracle Database.

Install Oracle.ManagedDataAccess.EntityFramework from nuget

https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/

Then install Oracle Developer Tools for Visual Studio 2015:

http://download.oracle.com/otn/other/ole-oo4o/ODTforVS2015_121025.exe

Here is my app.config:

<configSections>
<section name="oracle.manageddataaccess.client"
      type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
...
<entityFramework>
<providers>
<provider invariantName="Oracle.ManagedDataAccess.Client"
        type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>

...

However i got this error message when adding ADO.NET Entity Data Model: enter image description here

Any idea pls?

1
1
10/6/2016 8:30:28 AM

Accepted Answer

You have to install ODAC (Oracle Data Access Components).It offers four components that simplify .NET development with the Oracle Database:

-Oracle Data Provider for .NET

-Oracle Developer Tools for Visual Studio

-Oracle Providers for ASP.NET

-.NET stored procedures

In ODAC 12c Release 3 (12.1.0.2.1), Oracle includes Entity Framework 6 Code First and Code First Migrations. Also you can use ODAC 12c Release 4 includes support for Windows 10, Visual Studio 2015, .NET Framework 4.6 and more.

Oracle .NET Developer Center

If you have installed ODAC use Oracle.DataAccess.dll, add like reference to Your project.

Example path look like:

C:\app{userName}\product{version ODAC}\client_1\odp.net\bin{framework version}

C:\app\mww\product\11.2.0\client_1\odp.net\bin\4

1
10/6/2016 8:49:47 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow