Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

No Oracle DataSource in Entity Data Model Wizard

I am using ODP.NET and I need generate ORM from my database.

I have installed:

  • Visual Studio 2010 Ultimate
  • ODAC1120250Beta_EntityFramework_x64.zip

In Server Expolorer I can see Data Source for Oracle Database and I am able connect to remote oracle server and run queries.

When I add ADO.NET Entity Data Model and wanna generate code from database I cannot see Data source for oracle like in Server Explorer.

Do you need download some extra stuff to run entity framework with ODP.NET?

EDIT:

  1. Use latest version of ODP.NET
  2. Uncheck Oracle services for Microsoft Transaction Server .... During the installation
like image 325
312k1t Avatar asked Oct 19 '11 09:10

312k1t


1 Answers

You must install ODAC 11.2.0.2.30 or higher, 32-bit version. Entity Framework was not supported in earlier versions and it is not currently supported in 64-bit ODAC. see: https://forums.oracle.com/forums/thread.jspa?threadID=2202085

i do this (i had vs 2010 pro SP1 on W764), and use "ADO.NET Entity Data Model" for good work in LINK request.

"Classe LINK to SQL" dont work.

like image 133
maurice71 Avatar answered Oct 24 '22 08:10

maurice71