I have a problem with configuration... I created a solution with 4 layers (DAL, BL, Common and UI, that are 4 different .NET projects)
The UI layer is a web application configured by a web.config file. DAL, BL and Common are class library projects with an App.config file.
The Common layer contains the persistents classes. Its App.config file contains a <connection> node (inside the <openaccess> node) with the database connection information. DAL and BL also have database connection information in their App.config.
For the moment, Common, BL and DAL have each an App.config with a "Build Action" set to "Embedded Resource". Which means that if I need to change the database connection settings, I need to recompile the whole solution.
Is there a way to setup the database connection information (connection string) only in the web.config file and make Open Access use this piece of information. Then I would be able to change the conntection settings on the fly without having to recompile my solution ?