我在 web.config 中的现有连接字符串如下所示:
<connectionStrings>
<add name="SampleBloggingDbEntities"
connectionString="metadata=res://*/SampleDBModel.csdl|res://*/SampleDBModel.ssdl|res://*/SampleDBModel.msl;provider=System.Data.SqlClient;provider connection string="data source=My_System;initial catalog=SampleBloggingDb;persist security info=True;user id=sa;password=somepassword;MultipleActiveResultSets=True;App=EntityFramework""
providerName="System.Data.EntityClient" />
</connectionStrings>
somee.com 提供的连接字符串是:
workstation id=SampleBloggingDb.mssql.somee.com;packet size=4096;user id=some_id_SQLLogin_2;pwd=somepassword;data source=SampleBloggingDb.mssql.somee.com;persist security info=False;initial catalog=SampleBloggingDb
应如何将新连接字符串替换为现有连接字符串?
在你的网络中。Release.config 在代码上添加此行并在发布模式下发布项目
<connectionStrings xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
<add name="MyDB" connectionString="workstation id=SampleBloggingDb.mssql.somee.com;packet size=4096;user id=some_id_SQLLogin_2;pwd=somepassword;data source=SampleBloggingDb.mssql.somee.com;persist security info=False;initial catalog=SampleBloggingDb" xdt:Transform="Replace" xdt:Locator="Match(name)" />
</connectionStrings>
请注意,将MyDB
替换为连接字符串密钥名称。 这称为 Web.config 文件转换