I may be a bit over my head here - but hopefully someone can point me in the right direction.

Using the latest SOURCE files for SubSonic 2 - I need to be able to manipulate the CONNECTIONSTRING for specific requests based on the USER.

I thought I could modify DefaultConnectionString is DataProvider.cs - but HttpContext.Current ALWAYS seems to be null when that property is called (even when it is through a http request.)

When is that called by SubSonic? I'm assuming it is at a point when the page lifecycle DOESN'T exist and therefore the HTTPCONTEXT/PROFILE data is always missing.

Is there any way to work around this? Basically I have several identical structure databases I wish to access using SubSonic (same structures) and I want to choose the DB to use based on the current user's profile, any suggestions?