Error Creating a New Entity Data Model

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
kalel16
Posts: 2
Joined: Wed 12 Sep 2012 13:27

Error Creating a New Entity Data Model

Post by kalel16 » Wed 12 Sep 2012 13:32

I am trying to create a new entity data model...after choosing the database objects in the final step and clicking the ok button...nothing gets added to the EF model....In the error list window i see the error below:

Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
ORA-00942: table or view does not exist
'.

Environment: Visual Studio 2010
devart for Oracle version 7.2

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

Re: Error Creating a New Entity Data Model

Post by Shalex » Fri 14 Sep 2012 15:03

We cannot reproduce the problem at the moment. Please give us the following information:
1) the exact version of your Oracle server. Also specify Oracle client version if the OCI mode is used;
2) the script to create the database user you are connecting with;
3) are you choosing the database objects in Entity Data Model Wizard from your user's schema or from another one?

As a workaround, please use Entity Developer (the Devart Entity Model item).

kalel16
Posts: 2
Joined: Wed 12 Sep 2012 13:27

Re: Error Creating a New Entity Data Model

Post by kalel16 » Mon 17 Sep 2012 15:04

Thanks for your reply. I am attaching a document with the screenshots of the steps I took to create an Entity Model

Here is the environment

OS: Windows 7
Visual Studio 2010
Database server:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Solaris: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production

I am using the direct mode (used OCI mode also...same issue)...I am using an existing database user for connecting to the database...and yes I am using the database objects from the same users schema.

I have tried this on two machines...Both had Visual Studio 2010 and Devart 7.2 installed....Also tried in Visual Studio 2012....Same issue.

Let me know if you need any more details....

Hope to hear from you soon.

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

Re: Error Creating a New Entity Data Model

Post by Shalex » Tue 18 Sep 2012 09:21

We have asked for additional information by e-mail.

Post Reply