Change the connection string at runtime

I am doing a new project which try to utilize Quartz.Net to schedule the change of content base on Spring.Net and nHibernate.

The simple map is we have a regular process to deal with user’s request to change the content in the authoring environment and also input a schedule job into database by Quartz.Net. Another process, based on Windows Service will check the jobs queue, if the job startup time is up, then the process will update the content in the publish environment.

Seems the function is easy to implement. But we are frustrating for the timer job process to change database connection since the service module was based on Spring.Net and NHibernate.

After do some research and study, we finally found the solution to change connection string at runtime. (Beside this, actually there has another way to implement this function, by dual database provider).

This discussion thread detail the function implementation, and here is a great sample.