I'm trying to add edmx file in my project for first time. I want to choose the oracle provider ODP.net but cannot find Oracle in the data source list. I have oracle 11g installed , odp and odt installed and can access it from the solution as well. I saw the Oracle listed under data source when I tried to connect the solution to the database through server explorer. The solution is connected to Oracle database through ODP. Can anyone think of what needs to verified. Am I missing something?
Sorry, I meant the edition. :) Express, Professional, Ultimate?
Express is the free version you can download from Microsoft's webpage, and that one doesn't allow addins like the ODP developer tools. In that one, I'm not sure how to get it to work with EF.
Alright, that's weird. What should happen with that setup is that you can create a connection to Oracle in Server Explorer. If you do that, you should then be able to open up the Entity Framework wizard and use the connection you created in Server Explorer.
I'm having the same problem. As far as I know the only version of ODAC that I have installed is 18.104.22.168. What version did you ultimately install?
What I have:
- Visual Studio 2010 Ultimate
- .Net framework 4
- Entity Framework 4
- 64 Bit ODAC 22.214.171.124
Any help is greatly appreciated!
Edited by: AHowell1337 on Jan 2, 2013 7:25 AM
The Developer Tools for Visual Studio (the part that adds EF model wizard support) is only in the 32 bit ODAC, as Visual Studio is a 32 bit application.
You'll need to install that version before this works.