为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="data source=XXXX;initial catalog=XXXX;persist security info=True;user id=XXXX;password=XXXX;multipleactiveresultsets=True;application name=EntityFramework"" 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的连接字符串可以在应用程序配置文件中找到
推荐答案
请参阅类似的问题<一href=\"http://social.msdn.microsoft.com/Forums/windowsazure/en-US/62b9fa9d-7a4a-4927-a702-3e1e834d5187/azure-web-sites-connection-string-for-ef-not-being-picked-up\"相对=nofollow>这里。
你可以试试不web.config中的连接字符串用空(或无效)值。例如。
Try leaving the connection string in web.config with an empty (or dummy) value. e.g.
<connectionStrings>
<add name="DataContext" connectionString="dummy" providerName="System.Data.EntityClient" />
</connectionStrings>
这篇关于为EF Azure网站的连接字符串没有被拾起的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!