Alternatives to using web.config to store settings (for complex solutions)

Question

In our web applications, we seperate our Data Access Layers out into their own projects.

This creates some problems related to settings.

Because the DAL will eventually need to be consumed from perhaps more than one application, web.config does not seem like a good place to keep the connection strings and some of the other DAL-related settings.

To solve this, on some of our recent projects we introduced a third project just for settings. We put the setting in a system of .Setting files... With a simple wrapper, the ability to have different settings for various enviroments (Dev, QA, Staging, Production, etc) was easy to achieve.

The only problem there is that the settings project (including the .Settings class) compiles into an assembly, so you can't change it without doing a build/deployment, and some of our customers want to be able to configure their projects without Visual Studio.

So, is there a best practice for this? I have that sense that I'm reinventing the wheel.

Some solutions such as storing settings in a fixed directory on the server in, say, our own XML format occurred to us. But again, I would rather avoid having to re-create encryption for sensitive values and so on. And I would rather keep the solution self-contained if possible.

EDIT: The original question did not contain the really penetrating reason that we can't (I think) use web.config ... That puts a few (very good) answers out of context, my bad.

Answer 1

System.Configuration.ConfigurationManager.ConnectionStrings and System.Configuration.ConfigurationManager.AppSettings Contain settings from the executing application so in your DAL you can get the settings stored in your web.config file.

For your system you can create a custom configuration section that will sit in your web.config file or your DAL's consumer*.config file In these config files you can specify that they load from a separate config file of your design and location. Referencing external config files from Web.Config How to: Create Custom Configuration Sections Using ConfigurationSection

Alternativly you can manualy load your DAL configuration data from any file using ConfigurationManager.OpenExeConfiguration