Exception while generating model

[TroelsLarsen]

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.

[AndreyR]

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.

[TroelsLarsen]

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.

[Shalex]

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