blocks|key|1455980|text|不，您不能在运行时修改配置文件，它不是为此而设计的。也许您可以使用Enterprise+Libraries配置来做到这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1455981|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

No, you can't modify the config file at runtime, it isn't intended for that.
Maybe you could use the Enterprise Libraries Configuration to do that.

blocks|key|1670975|text|如果您试图在运行时编辑web.config中的连接字符串，请查看WebConfigurationManager。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1670976|如果您只是试图在运行时修改配置以注入连接字符串，那么您就不走运了。ConfigurationManager对象树是配置文件的直接反映，如果您能够更改该状态，则该状态将不一致。|1670977|我建议创建一个简单的facade类，您可以使用它来检索连接字符串。这样，您可以让facade从您的动态集合返回一个连接字符串，或者如果不存在连接字符串，它可以从ConfigurationManager中获取它。|1670978|class+ConnectionStringProvider
{
++++Dictionary<string,+System.Configuration.ConnectionStringSettings>+_localStrings+=+new+Dictionary<string,+System.Configuration.ConnectionStringSettings>();

++++public+void+AddLocalConnectionString(string+name,+string+connstring)
++++{
++++++++System.Configuration.ConnectionStringSettings+cs+=+new+System.Configuration.ConnectionStringSettings(name,+connstring);
++++++++_localStrings.Add(name,+cs);
++++}

++++public+void+RemoveLocalConnectionString(string+name)
++++{
++++++++_localStrings.Remove(name);
++++}

++++public+System.Configuration.ConnectionStringSettings+this[string+name]+{
++++++++get+
++++++++{+
++++++++++++return+_localStrings.ContainsKey(name)+?+_localStrings[name]+:+System.Configuration.ConfigurationManager.ConnectionStrings[name];+
++++++++}
++++}
}|code-block|syntax|javascript|1670979|或者你可以使用更多的东西，比如Enterprise+Library+Configuration+Block。|1670980|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/system.web.configuration.webconfigurationmanager.aspx^0|W|N|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

If you are trying to edit the connection strings in your web.config at runtime take a look at <a href="http://msdn.microsoft.com/en-us/system.web.configuration.webconfigurationmanager.aspx" rel="nofollow noreferrer">WebConfigurationManager</a>.

If you are just trying to modify the configuration at runtime to inject a connection string then you are out of luck. The ConfigurationManager object tree is meant to be a direct reflection of the configuration files, if you were able to change that the state would then be inconsistent.

I would recommend creating a simple facade class that you could use to retrieve your connection strings. This way you could have the facade return a connection string from your on the fly collection or if one doesn't exist then it could grab it from the ConfigurationManager.

<pre><code>class ConnectionStringProvider
{
 Dictionary&lt;string, System.Configuration.ConnectionStringSettings&gt; _localStrings = new Dictionary&lt;string, System.Configuration.ConnectionStringSettings&gt;();

 public void AddLocalConnectionString(string name, string connstring)
 {
 System.Configuration.ConnectionStringSettings cs = new System.Configuration.ConnectionStringSettings(name, connstring);
 _localStrings.Add(name, cs);
 }

 public void RemoveLocalConnectionString(string name)
 {
 _localStrings.Remove(name);
 }

 public System.Configuration.ConnectionStringSettings this[string name] {
 get 
 { 
 return _localStrings.ContainsKey(name) ? _localStrings[name] : System.Configuration.ConfigurationManager.ConnectionStrings[name]; 
 }
 }
}
</code></pre>

Or you could always go quite a bit heavier and use something like the Enterprise Library Configuration Block.

blocks|key|1671029|text|var+cfg+=+System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(@"/");
cfg.ConnectionStrings.ConnectionStrings.Add(new+ConnectionStringSettings(params));

cfg.Save();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1671030|请注意，这将导致您的网站回收，因为它修改了配置文件。查看http://msdn.microsoft.com/en-us/library/4c2kcht0(VS.80).aspx|unstyled|offset|length|1671031|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/4c2kcht0%2528VS.80%2529.aspx^0|0|S|1O|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code>var cfg = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(@"/");
cfg.ConnectionStrings.ConnectionStrings.Add(new ConnectionStringSettings(params));

cfg.Save();
</code></pre>

Be Advised this will cause your website to recycle since it modifies the config file. Check out <a href="http://msdn.microsoft.com/en-us/library/4c2kcht0%28VS.80%29.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/4c2kcht0(VS.80).aspx</a>

blocks|key|1456159|text|我还没有尝试过，但也许您可以在运行时更改现有连接字符串的值？例如，而不是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1456160|ConfigurationManager.ConnectionStrings.Add(new+ConnectionStringSettings(params));|code-block|syntax|javascript|1456161|也许你可以这样做：|1456162|ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString+=+"something";|1456163|如果是这样，您可以在config中指定连接字符串"variables“，但将它们设置为false或空的连接字符串：|1456164|<add+name="myconnection"+connectionString="SET+AT+RUNTIME"+...+/>|1456165|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Haven't tried it yet, but perhaps you can alter the value of an existing connection string at runtime? For example, instead of:

<pre><code>ConfigurationManager.ConnectionStrings.Add(new ConnectionStringSettings(params));
</code></pre>

Maybe you could do something like:

<pre><code>ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString = "something";
</code></pre>

If so, you could specify the connection string "variables" in config, but set them to false or empty connection strings:

<pre><code>&lt;add name="myconnection" connectionString="SET AT RUNTIME" ... /&gt;
</code></pre>

blocks|key|1671189|text|我只想指出，无论是谁给了您“安全要求”，即您不能将连接字符串放在web.config中，那么他就是一个笨蛋。除了您的应用程序或对服务器的远程访问之外，永远不能通过任何其他方式访问web.config。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1671190|这听起来完全像是一个需求问题，应该在那里解决。|1671191|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Just to point out whoever gave you the "security requirement" that you can't place the connection string in the web.config is an idiot. The web.config can never be accessed by anything other than your application or remote access to the server.

This sounds entirely like a requirements problem and should be solved there.

blocks|key|1456290|text|配置基础设施通过Windows+DataProtection+API支持非常健壮的加密，该API使用计算机特定的密钥对配置节进行加密。这样就不可能在任何地方读取加密数据，只能在加密数据的机器上读取。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1456291|此API与用于Windows中符合政府规定的驱动器/文件夹加密的API相同。这能满足贵公司的安全要求吗？|1456292|您可以手动执行此命令，也可以通过部署自动化来加密特定web应用程序的web.config的connectionStrings部分。|1456293|aspnet_regiis+-pe+"connectionStrings"+-app+"/MyCoolWebApplication"+-prov+"DataProtectionConfigurationProvider"|code-block|syntax|javascript|1456294|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The configuration infrastructure supports very robust encryption through the Windows DataProtection API wich uses a machine specific key to encrypt the configuration sections. This way it would not be possible to read the encrypted data anywhere but on the machine where it was encrypted.

This is the same API that is used for the Government compliant drive/folder encryption in Windows. Would this stand up to your companies security requirements?

Either manually or through your deployment automation you can execute this command to encrypt the connectionStrings section of your web.config for a specific web application.

<pre><code>aspnet_regiis -pe "connectionStrings" -app "/MyCoolWebApplication" -prov "DataProtectionConfigurationProvider"
</code></pre>

blocks|key|1671318|text|如果您使用的是MS+SQL，您可以配置您的web服务器通过windows身份验证来访问SQL+server，这样您就不需要在您的webconfig中有任何密码，甚至不需要在应用程序内存中到处浮动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1671319|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are using MS SQL you can configure you web server to access the SQL Server via the windows authentication, so you never have to have any passwords at all in your webconfig, or even floating around in your application memory.

blocks|key|1456384|text|您可以使用反射来禁用私有bReadOnly字段(不好的主意，等等)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1456385|typeof(ConfigurationElementCollection)
++++.GetField("bReadOnly",+BindingFlags.Instance+%7C+BindingFlags.NonPublic)
++++.SetValue(ConfigurationManager.ConnectionStrings,+false);
ConfigurationManager.ConnectionStrings.Add(new+ConnectionStringSettings());|code-block|syntax|javascript|1456386|这类似于modify+an+existing+connection+string所需的技术，并由Brian+Rodgers在那里作为注释添加。|offset|length|1456387|entityMap|0|LINK|mutability|MUTABLE|url|http://david.gardiner.net.au/2008/09/programmatically-setting.html^0|0|0|4|10|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You can use reflection to disable the private bReadOnly field (bad idea, etc.):

<pre><code>typeof(ConfigurationElementCollection)
 .GetField("bReadOnly", BindingFlags.Instance | BindingFlags.NonPublic)
 .SetValue(ConfigurationManager.ConnectionStrings, false);
ConfigurationManager.ConnectionStrings.Add(new ConnectionStringSettings());
</code></pre>

This is similar to the technique required to <a href="http://david.gardiner.net.au/2008/09/programmatically-setting.html" rel="noreferrer">modify an existing connection string</a>, and added as a comment there by Brian Rodgers.

Is there a way where I can add a connection string to the ConnectionStringCollection returned by the ConfigurationManager at runtime in an Asp.Net application?

I have tried the following but am told that the configuration file is readonly.

<pre><code>ConfigurationManager.ConnectionStrings.Add(new ConnectionStringSettings(params));
</code></pre>

Is there another way to do this at runtime? I know at design time I can add a connection string to the web.config; however, I'm looking to add something to that collection at run time.

Thanks

EDIT:
One of the reasons why I'm attempting to do this is due to a security requirement that prevents me from placing ConnectionStrings in the web.config (even encrypted). I would like to use elements like Membership and Profiles on my project; however, I am looking into an alternative to doing such w/o writing a custom provider. Custom Provider's aren't all that bad, but if I can find an easier solution, I'm all for it.

Can I Add ConnectionStrings to the ConnectionStringCollection at Runtime?

身份验证

服务器

Windows

有没有一种方法可以将连接字符串添加到Asp.Net应用程序中运行时由ConfigurationManager返回的ConnectionStringCollection？我已经尝试了以下操作，但被告知配置文件是只读的。ConfigurationManager.ConnectionStrings.Add(new Conne...

问我可以在运行时将ConnectionStrings添加到ConnectionStringCollection吗？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我可以在运行时将ConnectionStrings添加到ConnectionStringCollection吗？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我可以在运行时将ConnectionStrings添加到ConnectionStringCollection吗？
EN