ADO.Net Entity Data Model window takes forever to display the database objects

[evilneo]

I'm using visual studio 2013 Ultimate, dotConnect for Oracle version 9.9.887.0

at an ASP.NET MVC project after referencing the DLLs and adding the provider at the web.config
when adding new item at the model folder and choosing ADO.Net Entity Data Model, EF Designer from database and
specifying a connection using the dotConnect for oracle provider and testing connection is successful
then when pressing next the screen to choose the database objects takes forever to load the objects

only once where i left it to load for a very long time it actually retrieved the object and were able to continue on the project.

i also noticed that while it's loading Oracle RDBMS Kernel Executable is abnormally using about 15% CPU out of an i7 6700k

is there any solution to this?

[Shalex]

Please refer to https://www.devart.com/dotconnect/oracl ... izard.html > the "The Wizard Or EDM Designer Work Very Slowly" section. It includes possible workarounds.

We recommend you to use Entity Developer (the Devart Entity Model item, *.edml) instead of EDM Designer (the ADO.NET Entity Data Model item, *.edmx) because it is adjusted for working with Oracle and provides advanced functionality: http://www.devart.com/entitydeveloper/ed-vs-edm.html. Additionally, Entity Developer adds registration of EF6 provider in app.config automatically.