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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
evilneo
Posts: 1
Joined: Wed 27 Nov 2019 12:36

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

Post by evilneo » Wed 27 Nov 2019 12:56

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
Image
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
Site Admin
Posts: 9046
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Thu 28 Nov 2019 13:39

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.

Post Reply