更新连接字符串 [英] Update connection strings

问题描述

嗨.我正在尝试更新MSBuild自动部署的连接字符串.连接字符串在适当地称为"ConnectionStrings.config"的文件中.如下所示:

< connectionStrings>
< add name ="Schema1" connectionString ="数据源= DB1;用户ID = user ; Password = pwd ;" providerName ="Oracle.DataAccess.Client"； />
< add name =" Schema2" connectionString ="数据源= DB2;用户ID = user ; Password = pwd ;" providerName ="Oracle.DataAccess.Client"； />
< add name =" Schema2" connectionString =数据源= DB3；用户ID =用户；密码= pwd；" providerName =" Oracle.DataAccess.Client " />
</connectionStrings>

我尝试在我的项目文件中使用以下XmlUpdate目标作为连接字符串之一: >
.< XmlUpdate Prefix ="n"；命名空间="http://schemas.microsoft.com/developer/msbuild/2003"
XPath ="connectionPaths//add [@connectionString ='Data Source = DB1; User ID = user; Password = pwd; ']"

XmlFileName =" C:\ development \ connectionStrings.config"
Value =" connectionString =& quot;数据源= DB1；用户ID =用户；密码= pwd;" " />
</Target>

我最终将得到如下输出: connectionString =数据源= DB1；用户ID =用户；密码= pwd；" providerName ="Oracle.DataAccess.Client". connectionString =数据源= newDB1；用户ID =用户；密码= pwd；" </add>
如果解决方案是XmlUpdate，如何将更新限制为特定的"connectionString"?属性?

我也尝试了XmlMassUpdate，但是在connectionStrings文件中获取了错误的数据，或者什么也没有发生.没有错误，警告或配置文件更改.

我们非常感谢您的帮助.

Hi.  I'm trying to update connection strings for an MSBuild auto-deployment.  The connection strings are in a file appropriately called "ConnectionStrings.config" and looks like this:

<connectionStrings>
  <add name="Schema1" connectionString="Data Source=DB1;User ID=user;Password=pwd;"  providerName="Oracle.DataAccess.Client" />
  <add name="Schema2" connectionString="Data Source=DB2;User ID=user;Password=pwd;" providerName="Oracle.DataAccess.Client" />
  <add name="Schema2" connectionString="Data Source= DB3;User ID=user;Password=pwd;" providerName="Oracle.DataAccess.Client" />
</connectionStrings>

I tried using the following XmlUpdate target in my project file for one of the connection strings:

  <Target Name="UpdateDbConfig">
    <XmlUpdate Prefix="n" Namespace="http://schemas.microsoft.com/developer/msbuild/2003"
                XPath="connectionStrings//add[@connectionString = 'Data Source=DB1;User ID=user;Password=pwd;']"
                XmlFileName="C:\development\connectionStrings.config"
                Value=" connectionString=&quot;Data Source=DB1;User ID=user;Password=pwd;&quot; " />
  </Target>

I would end up with output like:

<add name="Schema1" connectionString="Data Source=DB1;User ID=user;Password=pwd;" providerName="Oracle.DataAccess.Client"> connectionString="Data Source=newDB1;User ID=user;Password=pwd;" </add>

If the solution is XmlUpdate, how can I limit the update to the specific "connectionString" attribute?

I also tried XmlMassUpdate, but I either get incorrect data in the connectionStrings file or nothing happens at all; no errors or warnings or changes to the config file. 

Any help is greatly appreciated.

推荐答案

我也尝试为这个.但是没有找到.

I also try to find a solution for this. But didn't find.

请让我知道解决方法

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