Change connection string reload app config at run time

Question

When I change the connection string using this code  it does not reload app config at runtime  I expected it to reload similarly to how we reload app config   config ConnectionStrings ConnectionStrings  JVVNL NEW Properties Settings JVVNL NEWConnectionString1   ConnectionString   ConString  config ConnectionStrings ConnectionStrings  CMS NEW Properties Settings JVVNL NEWConnectionString1   ConnectionString   ConString  config Save ConfigurationSaveMode Modified true   ConfigurationManager RefreshSection config ConnectionStrings SectionInformation SectionName

User · Answer

You can also refresh the configuration in it s entirety   ConnectionStringSettings importToConnectionString   currentConfiguration ConnectionStrings ConnectionStrings newName    if  importToConnectionString    null        importToConnectionString   new ConnectionStringSettings        importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName      importToConnectionString Name   newName      currentConfiguration ConnectionStrings ConnectionStrings Add importToConnectionString     else       importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName     Properties Settings Default Reload

User · Answer

Yeah  when ASP NET web config gets updated  the whole application gets restarted which means the web config gets reloaded

User · Answer

here is how to do it in Windows App Config  public static bool ChangeConnectionString string Name  string value  string providerName  string AppName                bool retVal   false          try                        string FILE NAME   string Concat Application StartupPath        AppName Trim      exe Config      the application configuration file name             XmlTextReader reader   new XmlTextReader FILE NAME               XmlDocument doc   new XmlDocument                doc Load reader               reader Close                string nodeRoute   string Concat  connectionStrings add                 XmlNode cnnStr   null              XmlElement root   doc DocumentElement              XmlNodeList Settings   root SelectNodes nodeRoute                for  int i   0  i  lt  Settings Count  i                                  cnnStr   Settings i                   if  cnnStr Attributes  name   Value Equals Name                       break                  cnnStr   null                             cnnStr Attributes  connectionString   Value   value              cnnStr Attributes  providerName   Value   providerName              doc Save FILE NAME               retVal   true                    catch  Exception ex                        retVal   false                Handle the Exception as you like                   return retVal

User · Answer

here is how to do it in Windows App Config  public static bool ChangeConnectionString string Name  string value  string providerName  string AppName                bool retVal   false          try                        string FILE NAME   string Concat Application StartupPath        AppName Trim      exe Config      the application configuration file name             XmlTextReader reader   new XmlTextReader FILE NAME               XmlDocument doc   new XmlDocument                doc Load reader               reader Close                string nodeRoute   string Concat  connectionStrings add                 XmlNode cnnStr   null              XmlElement root   doc DocumentElement              XmlNodeList Settings   root SelectNodes nodeRoute                for  int i   0  i  lt  Settings Count  i                                  cnnStr   Settings i                   if  cnnStr Attributes  name   Value Equals Name                       break                  cnnStr   null                             cnnStr Attributes  connectionString   Value   value              cnnStr Attributes  providerName   Value   providerName              doc Save FILE NAME               retVal   true                    catch  Exception ex                        retVal   false                Handle the Exception as you like                   return retVal

User · Answer

First you might want to add  using System Configuration    To your  cs file  If it not available add it through the Project References as it is not included by default in a new project   This is my solution to this problem  First I made the ConnectionProperties Class that saves the items I need to change in the original connection string  The  name variable in the ConnectionProperties class is important to be the name of the connectionString The first method takes a connection string and changes the option you want with the new value   private String changeConnStringItem string connString string option  string value                String   conItems   connString Split               String result               foreach  String item in conItems                        if  item StartsWith option                                 result    option         value                                  else                               result    item                                        return result          You can change this method to accomodate your own needs  I have both mysql and mssql connections so I needed both of them  Of course you can refine this draft code for yourself   private void changeConnectionSettings ConnectionProperties cp         var cnSection   ConfigurationManager OpenExeConfiguration ConfigurationUserLevel None        String connString   cnSection ConnectionStrings ConnectionStrings cp Name  ConnectionString       connString   changeConnStringItem connString   provider connection string   data source   cp DataSource        connString   changeConnStringItem connString   provider connection string   server   cp DataSource        connString   changeConnStringItem connString   user id   cp Username        connString   changeConnStringItem connString   password   cp Password        connString   changeConnStringItem connString   initial catalog   cp InitCatalogue        connString   changeConnStringItem connString   database   cp InitCatalogue              cnSection ConnectionStrings ConnectionStrings cp Name  ConnectionString   connString       cnSection Save         ConfigurationManager RefreshSection  connectionStrings        As I didn t want to add trivial information I ommited the Properties region of my code  Please add it if you want this to work   class ConnectionProperties       private String  name      private String  dataSource      private String  username      private String  password      private String  initCatalogue            lt summary gt          Basic Connection Properties constructor          lt  summary gt      public ConnectionProperties                          lt summary gt          Constructor with the needed settings          lt  summary gt           lt param name  name  gt The name identifier of the connection lt  param gt           lt param name  dataSource  gt The url where we connect lt  param gt           lt param name  username  gt Username for connection lt  param gt           lt param name  password  gt Password for connection lt  param gt           lt param name  initCat  gt Initial catalogue lt  param gt      public ConnectionProperties String name String dataSource  String username  String password  String initCat                 name   name           dataSource   dataSource           username   username           password   password           initCatalogue   initCat           Enter corresponding Properties here for access to private variables

User · Answer

IIRC  the ConfigurationManager RefreshSection requires a string parameter specifying the name of the Section to refresh    ConfigurationManager RefreshSection  connectionStrings      I think that the ASP NET application should automatically reload when the ConnectionStrings element is modified and the configuration does not need to be manually reloaded

User · Answer

You can also refresh the configuration in it s entirety   ConnectionStringSettings importToConnectionString   currentConfiguration ConnectionStrings ConnectionStrings newName    if  importToConnectionString    null        importToConnectionString   new ConnectionStringSettings        importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName      importToConnectionString Name   newName      currentConfiguration ConnectionStrings ConnectionStrings Add importToConnectionString     else       importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName     Properties Settings Default Reload

User · Answer

Had to do this exact thing   This is the code that worked for me   var config   ConfigurationManager OpenExeConfiguration ConfigurationUserLevel None   var connectionStringsSection    ConnectionStringsSection config GetSection  connectionStrings    connectionStringsSection ConnectionStrings  Blah   ConnectionString    Data Source blah Initial Catalog blah UID blah password blah   config Save    ConfigurationManager RefreshSection  connectionStrings

User · Answer

Had to do this exact thing   This is the code that worked for me   var config   ConfigurationManager OpenExeConfiguration ConfigurationUserLevel None   var connectionStringsSection    ConnectionStringsSection config GetSection  connectionStrings    connectionStringsSection ConnectionStrings  Blah   ConnectionString    Data Source blah Initial Catalog blah UID blah password blah   config Save    ConfigurationManager RefreshSection  connectionStrings

User · Answer

IIRC  the ConfigurationManager RefreshSection requires a string parameter specifying the name of the Section to refresh    ConfigurationManager RefreshSection  connectionStrings      I think that the ASP NET application should automatically reload when the ConnectionStrings element is modified and the configuration does not need to be manually reloaded

User · Answer

Here s the method I use  public void AddOrUpdateAppConnectionStrings string key  string value        try               var configFile   ConfigurationManager OpenExeConfiguration ConfigurationUserLevel None           var settings   configFile ConnectionStrings ConnectionStrings          if  settings key     null                        settings Add new ConnectionStringSettings key value                      else                       settings key  ConnectionString   value                    configFile Save ConfigurationSaveMode Modified           ConfigurationManager RefreshSection configFile ConnectionStrings SectionInformation Name           Properties Settings Default Reload              catch  ConfigurationErrorsException                Console WriteLine  quot Error writing app settings quot

User · Answer

Yeah  when ASP NET web config gets updated  the whole application gets restarted which means the web config gets reloaded

User · Answer

You can also refresh the configuration in it s entirety   ConnectionStringSettings importToConnectionString   currentConfiguration ConnectionStrings ConnectionStrings newName    if  importToConnectionString    null        importToConnectionString   new ConnectionStringSettings        importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName      importToConnectionString Name   newName      currentConfiguration ConnectionStrings ConnectionStrings Add importToConnectionString     else       importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName     Properties Settings Default Reload

User · Answer

Yeah  when ASP NET web config gets updated  the whole application gets restarted which means the web config gets reloaded

User · Answer

IIRC  the ConfigurationManager RefreshSection requires a string parameter specifying the name of the Section to refresh    ConfigurationManager RefreshSection  connectionStrings      I think that the ASP NET application should automatically reload when the ConnectionStrings element is modified and the configuration does not need to be manually reloaded

User · Answer

IIRC  the ConfigurationManager RefreshSection requires a string parameter specifying the name of the Section to refresh    ConfigurationManager RefreshSection  connectionStrings      I think that the ASP NET application should automatically reload when the ConnectionStrings element is modified and the configuration does not need to be manually reloaded

User · Answer

Yeah  when ASP NET web config gets updated  the whole application gets restarted which means the web config gets reloaded

User · Answer

You can also refresh the configuration in it s entirety   ConnectionStringSettings importToConnectionString   currentConfiguration ConnectionStrings ConnectionStrings newName    if  importToConnectionString    null        importToConnectionString   new ConnectionStringSettings        importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName      importToConnectionString Name   newName      currentConfiguration ConnectionStrings ConnectionStrings Add importToConnectionString     else       importToConnectionString ConnectionString   importFromConnectionString ConnectionString      importToConnectionString ProviderName   importFromConnectionString ProviderName     Properties Settings Default Reload

User · Answer

You can apply the logic in  Program cs     Logic for getting new connection string            MyDBName  mydb                 Assign new connection string to a variable string newCnnStr   a  Data Source   SQLExpress Initial Catalog     MyDBName     Persist Security Info True User ID sa Password mypwd      And Finally replace the value of setting Properties Settings Default  Nameof ConnectionString inSettingFile     newCnnStr     This method replaces the value at run time and also don t needs app config for the same setting  It will have the va ue till the application runs     It worked for me

User · Answer

First you might want to add  using System Configuration    To your  cs file  If it not available add it through the Project References as it is not included by default in a new project   This is my solution to this problem  First I made the ConnectionProperties Class that saves the items I need to change in the original connection string  The  name variable in the ConnectionProperties class is important to be the name of the connectionString The first method takes a connection string and changes the option you want with the new value   private String changeConnStringItem string connString string option  string value                String   conItems   connString Split               String result               foreach  String item in conItems                        if  item StartsWith option                                 result    option         value                                  else                               result    item                                        return result          You can change this method to accomodate your own needs  I have both mysql and mssql connections so I needed both of them  Of course you can refine this draft code for yourself   private void changeConnectionSettings ConnectionProperties cp         var cnSection   ConfigurationManager OpenExeConfiguration ConfigurationUserLevel None        String connString   cnSection ConnectionStrings ConnectionStrings cp Name  ConnectionString       connString   changeConnStringItem connString   provider connection string   data source   cp DataSource        connString   changeConnStringItem connString   provider connection string   server   cp DataSource        connString   changeConnStringItem connString   user id   cp Username        connString   changeConnStringItem connString   password   cp Password        connString   changeConnStringItem connString   initial catalog   cp InitCatalogue        connString   changeConnStringItem connString   database   cp InitCatalogue              cnSection ConnectionStrings ConnectionStrings cp Name  ConnectionString   connString       cnSection Save         ConfigurationManager RefreshSection  connectionStrings        As I didn t want to add trivial information I ommited the Properties region of my code  Please add it if you want this to work   class ConnectionProperties       private String  name      private String  dataSource      private String  username      private String  password      private String  initCatalogue            lt summary gt          Basic Connection Properties constructor          lt  summary gt      public ConnectionProperties                          lt summary gt          Constructor with the needed settings          lt  summary gt           lt param name  name  gt The name identifier of the connection lt  param gt           lt param name  dataSource  gt The url where we connect lt  param gt           lt param name  username  gt Username for connection lt  param gt           lt param name  password  gt Password for connection lt  param gt           lt param name  initCat  gt Initial catalogue lt  param gt      public ConnectionProperties String name String dataSource  String username  String password  String initCat                 name   name           dataSource   dataSource           username   username           password   password           initCatalogue   initCat           Enter corresponding Properties here for access to private variables

User · Answer

You can apply the logic in  Program cs     Logic for getting new connection string            MyDBName  mydb                 Assign new connection string to a variable string newCnnStr   a  Data Source   SQLExpress Initial Catalog     MyDBName     Persist Security Info True User ID sa Password mypwd      And Finally replace the value of setting Properties Settings Default  Nameof ConnectionString inSettingFile     newCnnStr     This method replaces the value at run time and also don t needs app config for the same setting  It will have the va ue till the application runs     It worked for me

User · Answer

Here s the method I use  public void AddOrUpdateAppConnectionStrings string key  string value        try               var configFile   ConfigurationManager OpenExeConfiguration ConfigurationUserLevel None           var settings   configFile ConnectionStrings ConnectionStrings          if  settings key     null                        settings Add new ConnectionStringSettings key value                      else                       settings key  ConnectionString   value                    configFile Save ConfigurationSaveMode Modified           ConfigurationManager RefreshSection configFile ConnectionStrings SectionInformation Name           Properties Settings Default Reload              catch  ConfigurationErrorsException                Console WriteLine  quot Error writing app settings quot

[c#] Change connection string & reload app.config at run time

Examples related to c#

Examples related to configuration