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 fromhere.This will allow you to connect to Oracle from a .NET application.
- 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.