Home
Do you store Application-Level Settings in your database rather than configuration files when possible?
  v1.0 Posted at 27/04/2018 7:23 AM by Tiago Araujo
For database applications, it is best to keep application-level values (apart from connection strings) from this in the database rather than in the web.config.  There are some merits as following:

  1. It can be updated easily with normal SQL e.g. Rolling over the current setting to a new value.
  2. It can be used in joins and in other queries easily without the need to pass in parameters.
  3. It can be used to update settings and affect the other applications based on the same database.​​

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments:

    Note: Social Media login for Yotpo is not working in IE or Safari, please use Chrome. We are waiting for Yotpo to fix it.