I have several projects in one solution. In one project lives all my datasets (DAL). They were developed using the dataset wizard and the connectionstring is coming from Settings file for that project.
The Startup project contains the User Interface (UI). I want to be able to control the database location (presumably from the application's App.config) file so that we can migrate easily from a test location to a live location and even (from the user.config file) a local data location for off-line use.
What is the best practice for, at run time, overriding the ConnectionString for the datasets in the DAL, since they currently come from their private settings ("My.settings") namespace?