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.

回答1:

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

回答2:

What worked for me is I changed my database compatibility back to 2012 before updating the model.

In SQL Management Studio, right-click on Database.

Properties-> Options -> Compatibility Level -> SQL Server 2012 (110)

回答3:

I updated to Cumulative update package 5 for SQL Server 2014 fixes but it doesn't work for me.Finally I solved this issue is update SQL Server 2014 service pack 1

http://www.microsoft.com/en-US/download/details.aspx?id=46694

回答4:

Building on what PretoriaCoder said Using SQL Server 2016 SP1 and Visual Studio 2017 with Entity Framework 6.2.0

Connecting to a 'our' DB compatibility set to 130, can generate the data model OK Connecting to a third party DB (set at 130) entity model generation fails.

Setting the compatibility of the DB to 110 (in SQL server) and the entity model gets generated.