subsonic 3.0.0.3 multiple database connection failover

Question

Possible Duplicate:
subsonic 3.0.0.3 multiple database connection failover

re-posted this is never seemed to actually go up onto the listings ????? bizzare

hi there,

am using MVC and Subsonic 3.0.0.3 but i cant seem to pin down a specific point for multiple database connection.

normally in normal .net i would have my 2 strings in the web.config file and have a database class for my project, within this db class i would do something like this:

try
        {
            conn.ConnectionString = server1;
            conn.Open();
        }
        catch (MySqlException)
        {
            conn.ConnectionString = server2;
            conn.Open();
        }

I am trying to pin down the one place in subsonic's created files where something like this would be best to place and maybe an up to date example on how to achieve it. I have googled etc but the examples shown are for an older subsonic.

many thanks