未拾取 EF 的 Azure 网站连接字符串 [英] Azure Web Sites connection string for EF not being picked up

问题描述

我正在将 ASP.NET Web 应用程序部署到 Azure 网站.

I am deploying an ASP.NET web app to Azure Web Sites.

该站点使用实体框架，当我在 Web.config 中包含以下内容时，它运行良好:

The site uses Entity Framework, and when I include the following in Web.config it runs fine:

<connectionStrings>
  <add name="DataContext" connectionString="metadata=res://*/Models.WpsData.csdl|res://*/Models.WpsData.ssdl|res://*/Models.WpsData.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=XXXX;initial catalog=XXXX;persist security info=True;user id=XXXX;password=XXXX;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

但是，如果删除此连接字符串并改为通过 Azure 管理门户指定，则会发生错误.

However, if this connection string is removed and instead specified via the Azure Management Portal, an error occurs.

Name:  DataContext
Value: metadata=res://*/Models.WpsData.csdl|res://*/Models.WpsData.ssdl|res://*/Models.WpsData.msl;provider=System.Data.SqlClient;provider connection string="data source=XXXX;initial catalog=XXXX;persist security info=True;user id=XXXX;password=XXXX;multipleactiveresultsets=True;application name=EntityFramework"
Type:  Custom

这会导致错误:在应用程序配置文件中找不到名为DataContext"的连接字符串.

推荐答案

查看类似问题 这里.

尝试在 web.config 中保留一些值(一些测试连接字符串或一些虚拟值)的连接字符串，例如

Try leaving the connection string in web.config with some value (either some test connection string, or some dummy value) e.g.

<connectionStrings>
  <add name="DataContext" connectionString="dummy" providerName="System.Data.EntityClient" />
</connectionStrings>

这篇关于未拾取 EF 的 Azure 网站连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！