Question

I have a config file and a pollingservice with different methods in the polling service. What i want to happen is that when it hits a certain method in the polling service i want to change the connection string in the config file from:

<add name="Entity" connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=dev;Initial Catalog=DB;Persist Security Info=True;User ID=a;Password=asdf;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

为此:

 <add name="Entity" connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=dev_Test;Initial Catalog=DB_Test;Persist Security Info=True;User ID=a;Password=asdf;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

请协助。

感谢。

Answer 1

如果你真的想要改变 app子,你可以这样做:

  var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

  config.ConnectionStrings.ConnectionStrings["Entity"].ConnectionString = YourNewConnectionString;
  config.Save();

如果你只需要改变数据来源是内部连接线,而你不想打平实体的连接线,那么你就可以利用连接线铺设建筑商:

var entityBuilder = new EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings["Entity"].ConnectionString);
var sqlBuilder = new SqlConnectionStringBuilder(entityBuilder.ProviderConnectionString);

sqlBuilder.DataSource = "dev_Test";

entityBuilder.ProviderConnectionString = sqlBuilder.ToString();

var connectionString = entityBuilder.ToString();

友情链接