Do you store Application-Level Settings in your database rather than configuration files when possible?
27/04/2018 7:23 AM by
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:
- It can be updated easily with normal SQL e.g. Rolling over the current setting to a new value.
- It can be used in joins and in other queries easily without the need to pass in parameters.
- It can be used to update settings and affect the other applications based on the same database.
Do you feel this rule needs an update?