Hello Devart,
On VS10 SP1 and dotConnect for Oracle 6.10.126 I have a serious problem when creating entities with the Data Model Wizard.
On a new solution, I add a Entity Data Model connected with my Oracle 11g db.
When I open the Wizard and select 2 or 3 tables, and click Finish, I have to wait a very long time (more than 15 minutes) before having the entities displayed in the model.
The problem is that the entities for ALL the tables in the db are created, not only the ones corresponding to the 2 or 3 db tables selected. Moreover, all views and procedures are also created in the model.
Please could you help?
Adriano
Serious problem with Data Model Wizard
More information
Hello,
Here is more info:
In Oracle I have 2 schemas SCHEMA1 and SCHEMA2
When I connect to the db, I use the user corresponding to SCHEMA2.
In SCHEMA2, I have no table. I have only views that are mapped to the corresponding tables in SCHEMA1.
In the Entity Data Model Wizard, under the "Tables" node I can find for example:
PERSON (SCHEMA1)
COUNTRY (SCHEMA1)
...
and under the "Views" node, there is:
PERSON (SCHEMA2)
COUNTRY (SCHEMA2)
...
This is correct as SCHEMA2 contains only views. The tables are really in SCHEMA1.
The problem occurs when, under the node "Tables", I select the table "PERSON (SCHEMA1)".
I have to wait infinitely and all database objects are created in the model, instead of just the table PERSON. To be precise, all the views are created as entities, plus all procedures. No entities related to tables.
It is not sure this is related with SP1 of VS 2010.
Could you help with this additional details?
Adriano
Here is more info:
In Oracle I have 2 schemas SCHEMA1 and SCHEMA2
When I connect to the db, I use the user corresponding to SCHEMA2.
In SCHEMA2, I have no table. I have only views that are mapped to the corresponding tables in SCHEMA1.
In the Entity Data Model Wizard, under the "Tables" node I can find for example:
PERSON (SCHEMA1)
COUNTRY (SCHEMA1)
...
and under the "Views" node, there is:
PERSON (SCHEMA2)
COUNTRY (SCHEMA2)
...
This is correct as SCHEMA2 contains only views. The tables are really in SCHEMA1.
The problem occurs when, under the node "Tables", I select the table "PERSON (SCHEMA1)".
I have to wait infinitely and all database objects are created in the model, instead of just the table PERSON. To be precise, all the views are created as entities, plus all procedures. No entities related to tables.
It is not sure this is related with SP1 of VS 2010.
Could you help with this additional details?
Adriano
The new build of dotConnect for Oracle 6.10.135 is available for download now. This build fixes the problem.
It can be downloaded from Download Page (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this post.
It can be downloaded from Download Page (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this post.