how to new connection add using oracle database ?

Question

hi frnds

I've working on visual studio 2013 and tried to setup Entity framework to access an oracle database.

I click on new ADO.NET entity model, then Generate from database, but on the data connection screen when I click "New Connection" I don't get oracle appearing the list of datasources. I only get two SQL server options.

Do I need to install something extra to get this to work?

why it doesn't work in 2013.

Bikesh Srivastava · Answer

Go on msdn site. https://msdn.microsoft.com/en-us/library/92ceczx1(v=vs.85).aspx

Nitin Sontakke · Answer

As I suggested before, please resolve connectivity issues from OUTSIDE of Visual Studio. Because we don't know how Visual Studio tries to connect.

Amit Kumar · Answer

Hi Dear, Follow the below link.. http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/GettingStartedNETVersion/GettingStartedNETVersion.htm http://www.oracle.com/technetwork/articles/dotnet/vs2010-oracle-dev-410461.html https://www.safaribooksonline.com/library/view/adonet-cookbook/0596004397/ch01s10.html

Anjali Khan · Answer

Hi Nitin when I connected oracle data base from to server explorer tht time from to data source showing oracle data base and connect it to then showing server name and uid pwd. I gave but not connected .

Nitin Sontakke · Answer

If there is something like "New OleDB Entity model" then you should select that one. Furthermore, you should already have Oracle client installed (I think). Please try all connectivity related things outside Visual Studio, for example, SQL*Plus, etc.