c# - Centralised Connection String for multiple application asp.net -
i have web server multiple application running. application have web.config file. if database password changes due policy have manually change password in each of web.config files in app setting section.
i reading connection string setting in machine.config file.
now question if put connection string in appsetting section of machine.config name connectionstring , same in web.config file overwrite machine.config file values.
in machine.config following setting
<configuration> .... <appsettings> <add key="connectionstring" value="value"/> </appsettings> </configuration> similarly in web.config file
<configuration> .... <appsettings> <add key="connectionstring" value="value"/> </appsettings> </configuration> and value in code below
string constring=configurationmanager.appsettings["connectionstring"]; will overloaded value?
what's going out here store connection string(s) in .config file , reference them either using file="" attribute or configsource="" attribute.
here's excellent question , answer talks differences between 2 , shows how implement them:
Comments
Post a Comment