Entity Framework Database-First with Oracle Database Entity Framework Database-First with Oracle Database oracle oracle

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

  1. generate create scripts from your SQL Server database,
  2. create the same tables in Oracle.
  3. Install ODP.NET fromhere.This will allow you to connect to Oracle from a .NET application.
  4. Now create a new edmx file from the tables in Oracle and if you doeverything properly, your application should be running.

Note: ODP.NET provider is only visible if you have a VS license. It is not visible on the free version.