c# - 为什么在使用 MySql 时出现 SQL Server 连接错误？

Question

An exception of type 'System.Data.SqlClient.SqlException' occurred in EntityFramework.dll but was not handled in user code

Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

web.config

  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  </configSections>
  <connectionStrings>
    <add name="WebFront" connectionString="Server=localhost;Database=webfront;Uid=devadmin;Pwd=*******" providerName="MySql.Data.MySqlClient" />
  </connectionStrings>

...  

  <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d">
      </provider>
    </providers>
  </entityFramework>  

从我的单元测试来看，一切都连接良好。这可能是因为除了连接字符串中的内容之外，我没有提供任何其他身份验证吗？网站上还有其他我遗漏的东西吗？不使用 Owin、Identity 或任何东西。在我添加所有花里胡哨的东西之前，我只是想学习一些基本的东西。

Answer 1

由于单元测试有效并且您在主应用程序/站点中遇到错误，我假设您在 visual studio 和 IIS 服务器中的主应用程序中运行了单元测试 - 这就是问题的根源，其中之一iis 中的配置不正确，请确保您的身份验证方法正确，并且应用程序池配置正确