Search code examples
c#entity-frameworkentity-framework-4sql-server-2012entity-framework-5

Entity Data Model Wizard Too Slow (SQL Database)


Using: visual studio 2012 Ultimate, ADO Entity Framework 6, Database: Sql express 2014 (installed on local PC), Database tables count: 174 table.

I am trying to create database model using Entity Data Model Wizard but it takes about 8 hours to create the model(Dialog not responding).

I tried to reinstall visual studio & Entity Framework but the same problem. I need any ideas that can speed up database model creation.

First image Second image Third image


Solution

  • Updating to Cumulative update package 5 for SQL Server 2014 fixes this issue, see https://connect.microsoft.com/VisualStudio/feedback/details/829555/visual-studio-freezes-during-entity-framework-db-reverse-engineering. The update is available at https://support.microsoft.com/en-us/kb/3011055