Exception while generating model

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 14
Joined: Thu 07 Aug 2008 09:42

Exception while generating model

Post by TroelsLarsen » Thu 07 Aug 2008 09:49

I'm trying to generate a model against a large Oracle database, it takes 6-8 minutes to fetch the list of objects (tables, views etc.) from the server. (Using the Entity Wizard)

After selecting two tables for modelling, it appears to freeze VS2008. Yesterday I decided to just let it be and went home after starting it.. Here is what greeted me this morning:
Added connection string to App.Config
ERROR: Unable to generate model due to the following exception: The store metadata has not been generated yet, please call GenerateStoreMetadata() first.
Loading metadata from database took 00:06:02.8438734
Generating model took 17:01:01.6690076
Writing out edmx file took 00:00:00.0977825
What is the problem, and why is it so slow? Note that there are roughly 700 tables in the schema. However, when using the Wizard, I am shown ALL objects on ALL schemas, meaning that there is almost 3000 tables alone?! Is there any way to have it consider only those in the proper schema? (Assuming the number of tables is the problem)

I can get everything to work if I connect to a server with a smaller number of tables.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 07 Aug 2008 10:58

The described situation is a known issue of the interaction between Oracle server and Microsoft EDM Wizard.
But we are working on the solution of this issue and on optimization.

Posts: 14
Joined: Thu 07 Aug 2008 09:42

Post by TroelsLarsen » Thu 07 Aug 2008 11:22

Excellent, thank you for your answer, I'm really hoping to be able to use the Entity Framework for our application. For now, I will install a local oracle server and reduce the number for tables.

Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 11 Sep 2008 12:26

The latest build of OraDirect .NET version 4.75.42 is available. Its performance is much better when working with large schemas.
You can download it from http://www.devart.com/oranet/download.html or from Registered Users' Area (for the Subscription program members only).

More about the new release: http://devart.com/forums/viewtopic.php?t=12859

Post Reply