Print Page | Close Window

Database switch at runtime guidelines

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1225
Printed Date: 14-May-2025 at 10:33pm


Topic: Database switch at runtime guidelines
Posted By: BenHayat
Subject: Database switch at runtime guidelines
Date Posted: 18-Apr-2009 at 5:00pm
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!


-------------
Best Regards!
..Ben

WPF & Silverlight Insider
http://www.MicroIntelligence.Com - http://www.MicroIntelligence.Com


Replies:
Posted By: BenHayat
Date Posted: 19-Apr-2009 at 5:12pm
I got a better understanding as I read pages 139 & 140 of user guide. However, I'd like to see a sample how at runtime you would change Datasource Keys to point to different databases with same schema!

Thanks!

[Update]
I went on reading and there is much more in the following pages. Should read 139-149!
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!


-------------
Best Regards!
..Ben

WPF & Silverlight Insider
http://www.MicroIntelligence.Com - http://www.MicroIntelligence.Com

Posted By: GregD
Date Posted: 22-Apr-2009 at 3:50pm
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.

Posted By: BenHayat
Date Posted: 22-Apr-2009 at 4:02pm
Excellent!

Thanks!


-------------
Best Regards!
..Ben

WPF & Silverlight Insider
http://www.MicroIntelligence.Com - http://www.MicroIntelligence.Com

Posted By: BenHayat
Date Posted: 21-May-2009 at 2:30pm
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?


-------------
Best Regards!
..Ben

WPF & Silverlight Insider
http://www.MicroIntelligence.Com - http://www.MicroIntelligence.Com

Posted By: GregD
Date Posted: 22-May-2009 at 11:06am
C:\Program Files\IdeaBlade DevForce\Learning Units\WinClient-Only\300 Advanced\DataSourceKeys\02 Code CSharp\Custom DataSourceKeyResolver

Posted By: BenHayat
Date Posted: 22-May-2009 at 11:20am
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.


-------------
Best Regards!
..Ben

WPF & Silverlight Insider
http://www.MicroIntelligence.Com - http://www.MicroIntelligence.Com

Posted By: ting
Date Posted: 29-May-2009 at 8:08am
Hi Ben,
 
I believe Greg contacted you via email a few days ago and can send you the example and answer any questions you may have.  If anyone else is interested in the sample, please contact mailto:support@ideablade.com - support@ideablade.com .  Thanks.
 


Print Page | Close Window