0

So in Visual Studio 2013 by default, when you start a new project, in your NuGet packages you have Entity Framework 6.1.1. We are still running Oracle 11.2 (11g), and of course you need at least 12c to be able to connect to EF6.

So I figure why not go back to EF5 and then this will not be an issue. However, when you uninstall 6, there are dependency issues. For example, if you are doing an MVC app, then you get the message "Unable to uninstall 'EntityFramework 6.1.1' because 'Microsoft.AspNet.Identity.EntityFramework 2.1.0' depend(s) on it.". Of course if you uninstall Identity EntityFramework and install EF5, then there is no compatible version of Identity framework, so your projects break.

Is there any way to get around this? We would like to use Entity Framework for our projects, but we know it will be a while until the database is updated from 11.2 to 12c, so we need a work around for now.

Improve this question
3
  • You don't need 12c database to use EF6. Just 12c of ODP.NET. Commented Jul 8, 2016 at 10:30
  • But that requires a server install, I tested the 12c NuGet package and it didn't work, I do not have access to make changes on the database. Commented Jul 9, 2016 at 11:22
  • During one of my project I started development with DevArt's oracle client. Database version was 11g. Then I switched to ODAC 12c without any changes at DB side. So it should work in your case as well. By the way DevArt's client can solve your problem too but personally I don't recommend it because of insufficient stability. Commented Jul 11, 2016 at 15:04

1 Answer 1

Reset to default
1

you have to install ODAC 12c Release 4 and Oracle Developer Tools for Visual Studio (12.1.0.2.4) in your machine where you have installed Visual Studio 2013

Then you have to use nuget in order to install the dlls in the project.

as @Alexey Merson says, you don´t need a 12c database in order to connect and work.

Before deploy the application to a server, you will have to install ODAC 12c Release 4 in the server too.

Hope it helps

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

This is not an option. For the DBA to make a change like this they have to undergo a LOT of testing and this has all been planned for next year. I will ask if he can install ODAC 12c, but I am guessing because of the size and complexity of the databases on the servers they will not want to do this.
Well, there should not be any differences using the 12c client. Anyway, if you want to avoid problems with the database people you can use Oracle Entity Framework 5 for Oracle 11.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.