Screen Getting Freeze When Updating Or Adding Tables To The Entity Framework Using The Wizard

Question

I'm using the Entity Framework and somehow it has started to get really slow when I'm trying to add or update the model.

Everything was working fine until someone execute some scripts to create some tables, and the scripts looks ok (she deleted it so i can't post it).

We have deleted those Tables and the problem is still there, and of course we don't have a back up.

If I click on the finish button the screen freeze but like in 20 minutes or more it finish correctly.

Does some one have had the similar problem in the past and give me some clue?

I can't see any log or any error in the screen so I'm super lost and looking for any idea.

Thanks in advance.

enter image description here

EDIT:

I'm Using Visual Studio 2012 and SQL Server 2014

This guy is having the same problem

score 3 · Accepted Answer · edited May 23 '17 at 12:15

3

I have found the solution:

It looks like is a problem with SQL 2014, you have to install this:

If you are curious here is more information:

edited May 23 '17 at 12:15

Community

answered Jul 22 '15 at 10:36

Stornu2

Thank you for posting your findings. I was experiencing similar issues and this helped out a lot. – Cory Sep 21 '15 at 19:31

score 0 · Answer 2 · answered Aug 22 '17 at 10:26

0

SQL Server may be holding the process, Try this

ALTER DATABASE [YOUR_DB_NAME]
SET COMPATIBILITY_LEVEL = 110;
GO

answered Aug 22 '17 at 10:26

Kavi

2 Answers2