Entity Framework Database-First with Oracle Database

Question

I'm developing an ASP.NET WebForms application with Entity Framework Database-First connected with SQL Server, and I want to connect the same Entity Data Model with Oracle Database.

My concerns are:

• How to install Oracle Database Engine on my dev machine to test?
• How to connect the data model with Oracle instead of SQL Server?
• How to generate the same schema into Oracle?
• Are there drivers, tools, or apps I need to install?

Answer 1

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 from here. 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 do everything 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.