更新向导没有响应 [英] Update wizard not responding

问题描述

每次我需要从数据库更新emdx时，更新向导都会花费大量的时间，因此一旦单击完成（完成更新）按钮，呈现自身就没有响应。

Every time I need to update my emdx from database, the update wizard takes an incredible amount of time to do so rendering itself as not responding once you hit the finish (as finish the update) button.

我使用Visual Studio 2015和LocalDb SQL Server2014。有人建议安装Service Pack 1来解决此问题。我已经为LocalDb安装了SP1，但没有帮助。我的VS2015安装也相当新。

I use Visual Studio 2015 and LocalDb SQL Server 2014. Some people suggested to install the Service Pack 1 to address the issue. I have installed the SP1 for LocalDb, but it has not helped. My installation of VS2015 is also rather new.

我有最新的Entity Framework 6版本（来自nuget）。

I have the latest Entity Framework 6 version (from nuget).

推荐答案

将数据库的兼容性级别设置为110对我有用。

Setting the compatibility level of the database to 110 has worked for me.

要检查兼容性级别，请运行此脚本：

To check the compatibility level, run this script:

select compatibility_level from sys.databases where name = '<YOUR_DB_NAME>'

要设置兼容性级别，请使用以下脚本：

To set the compatibility level, use this script:

alter database <YOUR_DB_NAME> set compatibility_level = 110

这篇关于更新向导没有响应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！