我如何在Web配置中覆盖连接字符串？ [英] How I Overwrite Connection String In Web Config ?

问题描述

我如何覆盖网络配置中的连接字符串？



i使用下面的代码

配置config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration（ 〜）; 
 ConnectionStringsSection section = config.GetSection（  MyConnectionString） as  ConnectionStringsSection; 
  //   section.SectionInformation.UnprotectSection（）;  
 section.SectionInformation。 ProtectSection（  DataProtectionConfigurationProvider）; 
 section =（ConnectionStringsSection）config.GetSection（  connectionStrings）; 
  if （section！=  null ）
 {
 section。 ConnectionStrings [  connectionStrings]。ConnectionString =  数据源= +服务器+  ;初始值Catalog = + Name +  ;用户ID = +用户名+  ;密码= +密码+  ; Pooling = true; Min Pool Size = 5; Max Pool Size = 60; Connect Timeout = 60; 
 config.Save（）; 
} 

但是'if condition'里面的代码抛出了一个对象引用错误..plz提出了一个解决方案问题..





section.ConnectionStrings [connectionStrings]。ConnectionString在add watch

解决方案

connectionStrings是节的名称而不是连接字符串名称。

  var  configuration = WebConfigurationManager.OpenWebConfiguration（ 〜）; 
  var  section =（ConnectionStringsSection）configuration.GetSection（ 的ConnectionStrings）; 
 section.ConnectionStrings [  MyConnectionString]。ConnectionString =  数据源= +服务器+  ;初始目录= +名称+  ;用户ID = +用户名+  ;密码= +密码+   ; Pooling = true; Min Pool Size = 5; Max Pool Size = 60; Connect Timeout = 60; 
 configuration.Save（）; 

我已从此链接

Hi,

How i overwrite connection string in web config ?

i used below code

Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
ConnectionStringsSection section = config.GetSection("MyConnectionString") as ConnectionStringsSection;
//section.SectionInformation.UnprotectSection();
section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
section = (ConnectionStringsSection)config.GetSection("connectionStrings");
if (section != null)
{
   section.ConnectionStrings["connectionStrings"].ConnectionString = "Data Source=" + Server + ";Initial Catalog=" + Name + ";User ID=" + Username + ";Password=" + Password + ";Pooling=true;Min Pool Size=5;Max Pool Size=60;Connect Timeout=60"; 
   config.Save();
}

But the code inside the 'if condition' throw an object reference error..plz suggest a solution for this issue..


section.ConnectionStrings["connectionStrings"].ConnectionString is show null in add watch

解决方案

The "connectionStrings" is the name of the section not the connection string name.

var configuration = WebConfigurationManager.OpenWebConfiguration("~");
var section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
section.ConnectionStrings["MyConnectionString"].ConnectionString = "Data Source=" + Server + ";Initial Catalog=" + Name + ";User ID=" + Username + ";Password=" + Password + ";Pooling=true;Min Pool Size=5;Max Pool Size=60;Connect Timeout=60";
configuration.Save();

I have copied solution from this link

这篇关于我如何在Web配置中覆盖连接字符串？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！