I just wanted to mention that the ActualConnectionString property is not only good for switching tween databases with identical schemas, but:

In the context of setting up a new app with a setup program it allows one to not have to edit the app.config or web.config files which requires a restart of app to see changes.

Found the code by searching the forum here, which is also a big plus.

Big help

Thanks,

Terry

Thanks for the feedback and great tip, Terry!