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?