code_junkie

Can I Add ConnectionStrings to the ConnectionStringCollection at Runtime?

Nov 12th, 2011
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. ConfigurationManager.ConnectionStrings.Add(new ConnectionStringSettings(params));
  2.  
  3. var cfg = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(@"/");
  4. cfg.ConnectionStrings.ConnectionStrings.Add(new ConnectionStringSettings(params));
  5.  
  6. cfg.Save();
  7.  
  8. class ConnectionStringProvider
  9. {
  10. Dictionary<string, System.Configuration.ConnectionStringSettings> _localStrings = new Dictionary<string, System.Configuration.ConnectionStringSettings>();
  11.  
  12. public void AddLocalConnectionString(string name, string connstring)
  13. {
  14. System.Configuration.ConnectionStringSettings cs = new System.Configuration.ConnectionStringSettings(name, connstring);
  15. _localStrings.Add(name, cs);
  16. }
  17.  
  18. public void RemoveLocalConnectionString(string name)
  19. {
  20. _localStrings.Remove(name);
  21. }
  22.  
  23. public System.Configuration.ConnectionStringSettings this[string name] {
  24. get
  25. {
  26. return _localStrings.ContainsKey(name) ? _localStrings[name] : System.Configuration.ConfigurationManager.ConnectionStrings[name];
  27. }
  28. }
  29. }
  30.  
  31. aspnet_regiis -pe "connectionStrings" -app "/MyCoolWebApplication" -prov "DataProtectionConfigurationProvider"
  32.  
  33. ConfigurationManager.ConnectionStrings.Add(new ConnectionStringSettings(params));
  34.  
  35. ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString = "something";
  36.  
  37. <add name="myconnection" connectionString="SET AT RUNTIME" ... />
Add Comment
Please, Sign In to add comment