Sql Server已更新至2014年& EF .edmx更新速度很慢 [英] Sql Server Updated to 2014 & EF .edmx update so slow
问题描述
您好，
在DDBB团队将Sql Server更新到2014年后，.edmx模型更新过程工作非常缓慢。我们几乎在所有项目中都使用EF 5.0数据库。
After DDBB team update Sql Server to 2014 versión, the .edmx models update process work very slow. We are using EF 5.0 database first in almost all our projects.
我看到在每个模型中打开的.xml都有属性 ProviderManifestToken =" ;的 2008 "与Sql Server 2008引擎相关，现在DDBB处于2008年的兼容模式。我是我工作的客户端的软件架构师
，DDBB部门为我的测试模型创建一个实验室环境，带有一个DDBB我在2014年设置了兼容模式，当我设置我的EF模型 ProviderManifestToken =" 2012 时，这是由EF 6.0生成的价值
项目连接到Sql Server 2014，没有错误，但更新模型过程需要花费很多时间，例如： 模型的更新过程时间与EF 5.0连接到
Sql Server 2014 但兼容模式= 2008 和
ProviderManifestToken =" 2008 "是：
I see that inside every model opened as .xml there is attribute ProviderManifestToken="2008" related to Sql Server 2008 engine, right now the DDBB are in compatibility mode of 2008. I'm the software Architect in the client i'm work, the DDBB department create a Lab environment for my test models with one DDBB with compatibility mode setted in 2014, when i set my EF model ProviderManifestToken="2012", that is a value generated by EF 6.0 project connected to Sql Server 2014, there isn't error but update model process take so much time, for example: The update process time of model with EF 5.0 connected to Sql Server 2014 but compatibility mode = 2008 and ProviderManifestToken="2008" is :
生成模型需要 00:00:02 .3354061
Generating the model took 00:00:02.3354061
与EF 5.0连接的相同型号到 Sql Server 2014 但兼容模式= 2014
和 ProviderManifestToken =" 2012" 是< span style ="font-size：0.75em; line-height：1.5">：
And the same model with EF 5.0 connected to Sql Server 2014 but compatibility mode = 2014 and ProviderManifestToken ="2012" is:
生成模型 00:06:22 0.7872939。 &NBSP; - >差不多7分钟的模型有一个表和一些SP。
Generating the model took 00:06:22.7872939. --> Almost 7 min a model with one table and a bit of SPs.
我已经将VS 2013的SSDT扩展更新到最新版本：12.0.50730.0
I have updated the SSDT extension for VS 2013 to the last version: 12.0.50730.0
欢迎任何帮助。
Any Help is welcome.
对不起，我的英语不太好。
Sorry for my english that is not so good.
最好的问候。
Orney。
推荐答案
您必须查看重复此过程的次数从一个版本的SQL Server到另一个版本。你这样看待它，然后你可能认为它并没有那么糟糕并处理它。
You have to look at how many times you are going to repeat this process as a whole going from one version of SQL Server to another. You look at it that way, then you may think it's not so bad and deal with it.
恕我直言，你可能无法得到它的解决方案。并且要说你要去Code First的另一个版本的EF，想想你可能面临的问题。
IMHO, you may not get a resolution to it. And to say that you are going to go to another version of EF like Code First, think of the issues you may face.
这篇关于Sql Server已更新至2014年& EF .edmx更新速度很慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
