UP AND RUNNING WITH ENTITY FRAMEWORK AND ORACLE

We are helping a healthcare client where they have large oracle implementation. We are moving from legacy client server applications to web based applications. We are successfully able to use Microsoft’s Entity Framework 5.0 with Oracle.

Since I am seeing so many hits on my blogs related to this topic, I will create one more useful blog on the same topic.

STEP #1

First you need to setup your development environment with Visual Studio 2012/2010 and install all the latest tools (MVC 4.0, NuGet Manager etc.)

STEP #2

Download and install Oracle Developer tools. This will install the Entity Framework provider that you can use with Visual Studio. Do not forget to install this not only on your development machine, but also on every machine your application needs to run.

You can download this from Oracle website here

http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html

 

image

 

STEP #3

Add/Edit connection information

image

 

STEP #4:

Select all your schemas, otherwise tables you need won’t show up in the browser to select (to be added on to the EF designer).

image

Tagged ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: