Problems with EF and Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
saunderl
Posts: 4
Joined: Fri 05 Aug 2011 18:28

Problems with EF and Oracle

Post by saunderl » Fri 05 Aug 2011 18:48

I'm trying to complete the simple tutorial @ http://www.devart.com/dotconnect/oracle ... al_EF.html

I've just installed dotConnect for Oracle Professional Edition 5.70.190.0
I've also just installed OraDeveloper Tools 2.60.176.0
(On Windows 7 / Visual Studio 2010 Ulitmate)

Steps 1-3 went just like clockwork. In step 4, after retrieving the Database Objects (It is a large Database with lots of tables) I have tried selecting all, some or just one of the tables.

No matter what I do, I do not get an Entity Data Model. Here is the error I always get:

"Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Can't found Project
'.

Here is the complete text from the Output window:

Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Can't found Project
'.
Loading metadata from the database took 00:00:13.4155130.
Generating the model took 00:00:01.5526171.
Added the connection string to the Web.Config file.
Successfully registered the assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' in the Web.Config file.
Writing the .edmx file took 00:00:00.0033893.

Please advise ... what am I doing wrong?

L. Lee Saunders

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 08 Aug 2011 09:31

You are using an old version of dotConnect for Oracle in Visual Studio 2010. Upgrade to the latest version of dotConnect for Oracle (6.30.196) to fix the issue with Entity Data Model Wizard (the "ADO.NET Entity Data Model" item) in VS 2010. As an alternative, you can create Entity Framework models in Entity Developer - add the "Devart Entity Model" item to your project (instead of "ADO.NET Entity Data Model") in step 4. Notify us about the results.

saunderl
Posts: 4
Joined: Fri 05 Aug 2011 18:28

Post by saunderl » Thu 18 Aug 2011 19:07

You were 100% right - once I got the latest version I could just fly with EF.

I even exposed some oracle tables as ODATA feeds!!!

Thanks!

Post Reply