Do you store Application-Level Settings in your database rather than configuration files when possible?
Last updated by SSW.Rules.SharePointExtractor almost 4 years ago.See historyFor 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.