Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be

user8600823Mar 19 2015 — edited Jul 9 2015

I am trying to build an MVC 5 Web application with EF 6 and Oracle. I am trying to use  , am trying to use Official ODP.NET Managed Entity Framework Driver from NuGet. I followed the direction in OBE to get that setup. Here is a link to that OBE Using NuGet to Install and Configure Oracle Data Provider for .NET.


Once that was setup I tried to add a model from DB using ADO.Net Entity Data Model.  It connects to the DB buyt

Your project references that latest version of entity framework; however, an Entity Framework database Provider compatible with this version could not be found for your connection...

How could I properly configure my application to be able to use ODAC with EF6 with DB/Model first?

I have VS 2013 Community Edition update 4. I am using Oracle 11g R2 DB if that matters.

I tried adding EF manually to newer version but that did not help. I did a rebuild of the application multiple times before I tried to add the model and that did not help either. I tried switching to x86 architecture but still get the same error.

Here is a part of my web.config file

<configuration>

  <configSections>

    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>

    <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>

  </configSections>

  <entityFramework>

    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">

      <parameters>

        <parameter value="v12.0"/>

      </parameters>

    </defaultConnectionFactory>

    <providers>

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>

      <provider invariantName="Oracle.ManagedDataAccess.Client" type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>

    </providers>

  </entityFramework>

  <system.data>

    <DbProviderFactories>

      <remove invariant="Oracle.ManagedDataAccess.Client"/>

      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>

    </DbProviderFactories>

  </system.data>

  <oracle.manageddataaccess.client>

    <version number="*">

      <dataSources>

        <dataSource alias="PVMDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lcoalhost)(PORT=11086))(CONNECT_DATA=(SERVICE_NAME=DDS1086))) "/>

      </dataSources>

    </version>

  </oracle.manageddataaccess.client>

  <connectionStrings>

    <add name="OracleDbContext" providerName="Oracle.ManagedDataAccess.Client" connectionString="User Id=pvm;Password=pvm Source=PVMDataSource"/>

  </connectionStrings>

What am I missing?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2015
Added on Mar 19 2015
9 comments
36,208 views