使用Entity Framework 6和SQL Server 2016时出现性能问题 [英] Performance problems when using Entity Framework 6 and SQL Server 2016

问题描述

我正在使用 VS2015 与 EntityFramework 6 来映射我的
SQL Server 2012 数据库。在将
SQL Server升级到2016 版本之前，一切正常。现在，当我更新我的数据库模型时，Visual Studio崩溃了。其他问题是，有时我在运行应用程序时遇到错误：
"TCP信号量超时期限已过期"。 

I was using VS2015 with EntityFramework 6 for mapping my SQL Server 2012 database. Everything worked fine until upgrade the SQL Server to 2016 version. Now, when I update my database model, Visual Studio crash. Other problem is that sometimes I have that error while running the application: "TCP semaphore timeout period has expired". 

任何人都知道有关 EF6 与
SQLServer 2016 之间兼容性的问题？

Anyone knows issues about compatibility between EF6 and SQLServer 2016?

谢谢，

推荐答案

你好caglianone，

Hi caglianone,

根据你的说法描述，您是否首先使用实体​​框架6 数据库并从数据库更新模型，遇到问题？

According to your description, do you use entity framework 6 database first and update model from database, which encounter the issue?

根据您的错误消息，似乎实体框架无法连接数据库。请检查网络配置和防火墙是否阻止。

Based on your error message, it seems that entity framework could not connect the database. please check if the networking configuration and firewall is block.

请使用SSMS连接您的SQL Server 2016并检查它是否可以连接它。

Please use SSMS to connect your SQL server 2016 and check if it could connect it.

祝你好运，

Cole Wu

这篇关于使用Entity Framework 6和SQL Server 2016时出现性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！