Hi ,
I am building a asp.net application and I need to specify a different database for different types of users. Of course the schema is same for all databases.
I want to be able to specify a dynamic connection string / provider once the user logs in and keep that for the session.
How do it go about doing this.
I have seen the earlier posts titled "Subsonic: dynamic connection" but that does not tell me how do I handle this globally, per session basis.
Thanks