we have a weird issue with Visual Studio 2012 and Entity Data Modeler with ODAC 11.2 Release 5 (184.108.40.206.20) and Oracle 11.
If we create a new Ado.Net EDM with this configuration and Oracle 10 , the tables of the schema are shown very fast, then we select the desired tables and the model is generated in a few seconds.
If we try to do the same thing to a similar schema but with Oracle 11 instead of Oracle 10, the process related with the creation of the model takes more than 2 minutes to complete.
Could anyone help us with this issue?
In Server Explore for the Oracle 11 database connection, choose Modify Connection for the connection you are using and check the "Filters" Tab. Make sure that public synonyms are not allowed to be displayed and also consider trying to add some additional filtering in case this particular database has a huge amount of schema objects.
You can verify the filters are working by drilling down in Server Explorer. Once you have done this, then go back to the Entity Designer and see if the problem still reproduces.
Failing that is there anyway you can try this with the latest ODAC (12.1) and see if the problem reproduces?