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

asp.net-mvc entity-framework-6 oracle

Question

can someone help me with this error ? Error after set up connection string and confirm

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

and that generate this providers in 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" />

Does anyone get this work ? What i'm missing ? Thanks for every hint

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You need to install the Entity Framework Oracle provider. You can do that in two ways:

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

    Install-Package Oracle.ManagedDataAccess.EntityFramework

  2. Follow the instruction for NuGet ODP.NET Installation and Configuration from here

Using NuGet to Install and Configure Oracle Data Provider for .NET

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 just ran into this myself. The connection string name must match the class name of your DbContext subclass exactly. If it doesn't EF will not find the connection string and will try and fall back to doing something else (SQL embedded?) which doesn't work on my machine (I have full SQL Server installed).
entity-framework
asked by jlew

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

See ...Using Entity Framework (code first) migrations in production... so that your application automatically updates the database when the Entity Framework initializes....Now if you're more comfortable having manual control over the migration, you could use the -Script argument to the Update-Database command on your developer machine to generate S...
asp.net-mvc c# entity-framework
asked by David Moore

Create one to one relationship by using entity framework database first

Creating a 1:1 relationship is not that tricky and certainly not impossible, although it is not a particularly common requirement and in this case I can't see why you would want it? If people are saying this then you are talking to the wrong people. ...Anyhow using SQL queries as you seem to be is not to do with EF, you are just working directly wi...
ef-code-first ef-database-first entity-framework one-to-one
asked by Dave Williams

Entity Framework Database-First with Oracle Database

I am doing exactly the same as you ...i.e. Converting a ASP.NET MVC application on SQL server to Oracle. ...Since your application is already running, what you can do, is ...generate create scripts from your SQL Server database,...create the same tables in Oracle....Install ODP.NET from ...here.... This will allow you to connect to Oracle from a .N...
entity-framework oracle
asked by Ashutosh

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

If you want to manage the ...AspNetUsersRoles..., you must make the following modification....Remove the primary key, actually is conformed by UserId and RoleId...Add a new Id field in the table and check like primary key....Update your model....Now you can scaffolding this entity and create the controller and the view for manage this....Note: Rem...
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?

You can't implement a 2nd parameterless constructor ...User()..., because there is already one in the auto-generated class....Hence, you have only 2 options to resolve this issue:...Inherit from the original class ...User... (see below)....Modify the ...T4-template... so the parameterless constructor is generated with the extra code ...DateCreated ...
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

I finally was able to to use ODP with EF6....I did the following to make it work :-...First Installing ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. As per...http://www.oracle.com/technetwork/topics/dotnet/whatsnew/index.html...
.net ado.net-entity-data-model entity-framework odac oracle
asked by Wasef Anabtawi

Update existing database with Entity Framework Code First in MVC

Why did you do steps 1-4? That's where you went wrong. If you had a previously generated database and you're just making changes to the schema, then just generate a migration and apply it. By doing steps 1-4, you're effectively undoing Entity Framework's knowledge of this database and essentially ending up with code-first with an existing database....
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

It's not necessary to define two different mapping for specific entities. All I need was to map a ...one-to-many... relation via fluent api. ...Here are the changes:...public class Office { // fk field to the entity public Guid ManageId{get;set;} public virtual Person Manager {get; set;} public virtual List<Person> People {get; set...
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

The trick is to have the connection string in the client project, in your case MVC project. Either in a web.config or app.config. In your case, it's web.config file. Then you can safely generate your EntityFramework classes in your class library, and can refer to it from any type of project.
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