Entity Framework 6, database-first with ORACLE in MVC 5.2.3 project

asp.net-mvc entity-framework-6 oracle

Question

Can somebody assist me with this mistake? Error after set up connection string and confirm

I'm using.NET 4.6 and MVC 5.2.3. I installed Oracle Developer Tools for Visual Studio (12.1.0.2.4) and ODAC 12c Release 4 from the official Oracle website here (http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html), then I added NuGet packages. Oracle.ManagedDataAccess and the entity framework associated with it

as well as those who create these providers in the webconfig file:

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


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

Anyone who understands this work? What am I overlooking? Thank you for your advice.

1
1
8/2/2018 9:15:42 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Installing the Entity Framework Oracle provider is necessary. There are two methods to achieve that:

  1. In the Package Manager Console execute the following command:

    Oracle.ManagedDataAccess.EntityFramework should be installed.

  2. From this page, follow the instructions for installing and configuring NuGet ODP.NET.

Oracle Data Provider for.NET Install and Configuration Using NuGet

1
8/2/2018 10:35:23 AM

Related Questions

code first entity framework 4.1 The permission to CREATE DATABASE was refused in the database'master.'

I recently encountered this issue. Your DbContext subclass's class name must precisely correspond to the connection string's name. If it doesn't, EF won't be able to locate the connection string and will attempt to fall back to an other method (SQL embedded? ), which is ineffective on my computer (I have full SQL Server installed).
entity-framework
asked by jlew

Entity framework code first - how to run Update-Database for production database

ZZZ_tmp
asp.net-mvc c# entity-framework
asked by David Moore

Create one to one relationship by using entity framework database first

It's not difficult to establish a 1:1 relationship, but I don't get why you would want one in this situation. It's not an usual demand, either. You are conversing with the incorrect people if this is what they are saying....However, as you seem to be doing, utilizing SQL queries has nothing to do with EF; rather, you are just interacting with the d...
ef-code-first ef-database-first entity-framework one-to-one
asked by Dave Williams

Entity Framework Database-First with Oracle Database

ZZZ_tmp
entity-framework oracle
asked by Ashutosh

AspNetUserRoles Table is not populated using Entity Framework Database First in MVC 5

ZZZ_tmp
asp.net-mvc asp.net-mvc-5 entity-framework
asked by William Ballesteros

How can you change the parameterless constructor of an Entity Framework 6 database-first generated class?

ZZZ_tmp
ef-database-first entity-framework-6
asked by Matt

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

ZZZ_tmp
.net ado.net-entity-data-model entity-framework odac oracle
asked by Wasef Anabtawi

Update existing database with Entity Framework Code First in MVC

How come you followed steps 1-4? That is where you erred. Simply create a migration and apply it if all you're doing is making changes to the schema in an already generated database. As a result of steps 1-4, Entity Framework's knowledge of this database is basically undone, and you end up with a code-first approach with an existing database. At th...
asp.net-mvc ef-code-first entity-framework sql-server updatemodel
asked by Chris Pratt

One-to-one and one-to-many on the same entity in Entity Framework

ZZZ_tmp
ef-fluent-api entity-framework entity-framework-6
asked by Ali Bahrami

How to use Entity Framework 6 Code First in Class Library Project with MVC 5

ZZZ_tmp
asp.net-mvc c# class-library entity-framework-6
asked by Tolga Evcimen

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

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