Page 1 of 1
Problem with lots of tables
Posted: Wed 11 Jan 2012 18:54
by rick.duarte
I'm trying to add some tables from another user on Entity Developer, but everytime that I expand the tables group, the application becomes unresponsive.
I don't have this problem with others users tables.
When I browse the users tables using Toad, I could notice that he have 735 tables!!!
So my question is: Could that be a problem? Do you have any ideas?
Best regards,
Henrique
Posted: Mon 16 Jan 2012 13:48
by Shalex
rick.duarte wrote:everytime that I expand the tables group, the application becomes unresponsive.
1. Does it take several seconds (it's possible because there is a lot of tables) or minutes to respond? Or it hangs and never responds?
2. Try adding these tables via Create Model Wizard when creating a new model. Does it help?
3. Tell us the versions of your Entity Developer (x.xx.xxx) and Oracle server.
Posted: Mon 16 Jan 2012 16:20
by rick.duarte
Shalex wrote:
1. Does it take several seconds (it's possible because there is a lot of tables) or minutes to respond? Or it hangs and never responds?
It hangs and never responds. I tried it at night and when I came back at the morning, the message was still there.
Shalex wrote:
2. Try adding these tables via Create Model Wizard when creating a new model. Does it help?
I tried using Create Model Wizard and appending the tables latter with Update from Database and the error persists.
Shalex wrote:
3. Tell us the versions of your Entity Developer (x.xx.xxx) and Oracle server.
I'm using dotConnect for Oracle 6.60.268, Entity Developer 4.2.95 and Oracle 11g.
PS: This error doesn't occurs with ODP.NET (from Oracle) that works with Entity Framework.
Posted: Thu 19 Jan 2012 15:27
by Shalex
1. Could you please confirm that you are using Devart Entity Model (*.edml), not ADO.NET Entity Data Model (*.edmx)?
2. If possible,
send us the DDL script of your database. Which tables should we select in Create Model Wizard and which ones in Update from Database?
3. Try using the latest (6.60.283) version of dotConnect for Oracle.
4.
rick.duarte wrote:I tried using Create Model Wizard and appending the tables latter with Update from Database and the error persists.
Does it work if you are adding the tables in Create Model Wizard (not via Update from Database)?