Database switch at runtime guidelines

Hi;

My objective is to have one database that holds a list of users, their ID, password, other info and most importantly which database their data reside in.

Then I will have a series of databases (all the same schema) except each one would holds data for different company. After a user logs in, I'd like to access the first database to find out out which database to open, and then at runtime, open up the database for the logged in user.

Is there any proper patterns or guidelines to do this with Devforce that is already tested and should be followed?
Thanks!

Originally posted by BenHayat I still would like an stand alone small sample showing same database schema, different data and switching at runtime without getting those extension keys from. App.config bur from user database!

Ben, there will be an example included in next release of DevForce, scheduled in a couple of weeks.

Originally posted by GregD Originally posted by BenHayat I still would like an stand alone small sample showing same database schema, different data and switching at runtime without getting those extension keys from. App.config bur from user database! Ben, there will be an example included in next release of DevForce, scheduled in a couple of weeks.

Greg, can you tell me where this sample is as part of RC2?

Originally posted by GregD C:\Program Files\IdeaBlade DevForce\Learning Units\WinClient-Only\300 Advanced\DataSourceKeys\02 Code CSharp\Custom DataSourceKeyResolver

Hi Greg;
As part of my Silverlight installations, I don't have the WinClient-only folder and the project you mentioned.