My team has an Oracle database with about 100 tables and about 30 views. A few weeks ago, we noticed when adding a new table from the database to our Entity Framework data model (through the EDMX designer, the update model from the database wizard) that the update hung - it returned several times after 15 minutes, but most often we killed Visual Studio or interrupted the update.
I experimented to check if I can isolate the problem. I destroyed the old diagram and all the models. I created a new chart and started adding tables - first one at a time, then 3, 4 or 5 at a time. To create a model, the first addition took about 15 seconds.
Loading metadata from the database took 00:00:00.5137297.
Generating the model took 00:00:14.8504157.
Each subsequent addition (from 1-5 other tables) took a couple of seconds.
Loading metadata from the database took 00:00:00.5682151.
Generating the model took 00:00:17.2365107.
Loading metadata from the database took 00:00:00.5065684.
Generating the model took 00:00:18.1086428.
75 30 .
Loading metadata from the database took 00:00:00.5524721.
Generating the model took 00:00:30.5682269.
80 . 80- . .
, , , , - .
, - , , 80 .
- , ?
( - - .. , "80".)
:
Visual Studio Pro 2012.
system.data.entity.dll, runtime v4.0.30319, 4.0.0.0.
EntityFramework.dll runtime v4.0.30319, 5.0.0.0 (< - - ?)