DevForce Community Forum : Switching Connection String at Runtime http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Switching Connection String at Runtime Tue, 21 Apr 2026 10:40:12 -700 Thu, 10 Jun 2010 16:01:31 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1860 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Switching Connection String at Runtime : See the Data folder that accompanies... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7258#7258 Author: GregD
Subject: 1860
Posted: 10-Jun-2010 at 4:01pm

See the Data folder that accompanies the two DataSourceKey solutions. It contains two zips which contain a total of three databases: Tenant, Tomato01, and Tomato02. You need to attach those to your instance of SQL Server.]]> Thu, 10 Jun 2010 16:01:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7258#7258 Switching Connection String at Runtime : Do you have any data in that sample... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7255#7255 Author: jmarbutt
Subject: 1860
Posted: 10-Jun-2010 at 11:34am

Do you have any data in that sample app? It appears that I am not building my connection string correctly, I would like to compare what the connection string being past to the ClientEdmKey.

I think I just have something slightly off.]]> Thu, 10 Jun 2010 11:34:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7255#7255 Switching Connection String at Runtime : You're right that we're... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7252#7252 Author: kimj
Subject: 1860
Posted: 10-Jun-2010 at 11:01am

You're right that we're still missing documentation on how DevForce probes for custom implementations.  Briefly, we're using MEF (Managed Extensibility Framework) for most probing.  When you implement a DevForce interface, or sub-type a base class, that type has been marked with the MEF InheritedExport attribute, which means that when a custom implementation is supplied MEF "should" find it.  By default, in a .NET application that discovery will be in the exe/bin folder, and in Silverlight the XAP file. 
 
As for what's used server-side vs. client side, or both, right now that's usually described in the API Reference Help.  There's also more information in the Deployment chapter in the Learning Resources.  In the case of the IDataSourceKeyResolver, although you can deploy your custom class to both client and server, it's only on the server that actual connection string resolution is required.
]]> Thu, 10 Jun 2010 11:01:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7252#7252 Switching Connection String at Runtime : Nevermind, I guess it is using... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7251#7251 Author: jmarbutt
Subject: 1860
Posted: 10-Jun-2010 at 10:30am

Nevermind, I guess it is using reflection to do that, pretty cool, but could be better documented about that.]]> Thu, 10 Jun 2010 10:30:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7251#7251 Switching Connection String at Runtime : I think my question around this... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7250#7250 Author: jmarbutt
Subject: 1860
Posted: 10-Jun-2010 at 10:23am

I think my question around this is how does the EntityManager know how to use the CustomDataSourceKeyResolver? I don't see it assigned any where. ]]> Thu, 10 Jun 2010 10:23:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7250#7250 Switching Connection String at Runtime : Originally posted by DavidKozikowskiThe... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7237#7237 Author: GregD
Subject: 1860
Posted: 09-Jun-2010 at 5:47pm

Originally posted by DavidKozikowski

The info in that section of documentation for DevForce 2010 states "Coming Soon!"


Maybe we just got it back in there for this release. I was looking at the docs going out with 6.0.3.]]> Wed, 09 Jun 2010 17:47:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7237#7237 Switching Connection String at Runtime : Originally posted by jmarbuttI... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7236#7236 Author: GregD
Subject: 1860
Posted: 09-Jun-2010 at 5:45pm

Originally posted by jmarbutt

I am wanting to change the connection based on the authenticated user.


Sure, but I don't understand why you asked this question:

Originally posted by jmarbutt

Does this show how to do it only from the server side of the Silverlight application?


The only place the connection string will be used is server-side.]]> Wed, 09 Jun 2010 17:45:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7236#7236 Switching Connection String at Runtime : Originally posted by GregDIn... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7218#7218 Author: DavidKozikowski
Subject: 1860
Posted: 09-Jun-2010 at 6:12am

Originally posted by GregD

In the Learning Resources, see the material on DataSourceKeys, DataSourceKeyResolvers, and DataSourceExtensions in the Business Object Persistence_Advanced topic document. There are also two Visual Studio solutions that address the topic, both in the folder Learning Resources\040_BusObjPersistence\DataSourceKeys.
 

The info in that section of documentation for DevForce 2010 states "Coming Soon!"

I do need some help / direction on what the App.Config file needs to look like when there are several databases involded. Can you provide a sample App.config file?
 
]]> Wed, 09 Jun 2010 06:12:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7218#7218 Switching Connection String at Runtime : I am wanting to change the connection... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7213#7213 Author: jmarbutt
Subject: 1860
Posted: 08-Jun-2010 at 7:12pm

I am wanting to change the connection based on the authenticated user.

I am also trying to implement the custom authentication but haven't gotten that working yet either.]]> Tue, 08 Jun 2010 19:12:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7213#7213 Switching Connection String at Runtime : Tell me a bit more about what... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7209#7209 Author: GregD
Subject: 1860
Posted: 08-Jun-2010 at 5:41pm

Tell me a bit more about what you're trying to do.]]> Tue, 08 Jun 2010 17:41:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7209#7209 Switching Connection String at Runtime : Does this show how to do it only... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7208#7208 Author: jmarbutt
Subject: 1860
Posted: 08-Jun-2010 at 3:16pm

Does this show how to do it only from the server side of the Silverlight application?]]> Tue, 08 Jun 2010 15:16:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7208#7208 Switching Connection String at Runtime : In the Learning Resources,... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7177#7177 Author: GregD
Subject: 1860
Posted: 07-Jun-2010 at 12:20pm

In the Learning Resources, see the material on DataSourceKeys, DataSourceKeyResolvers, and DataSourceExtensions in the Business Object Persistence_Advanced topic document. There are also two Visual Studio solutions that address the topic, both in the folder Learning Resources\040_BusObjPersistence\DataSourceKeys.


Edited by GregD - 07-Jun-2010 at 12:21pm]]> Mon, 07 Jun 2010 12:20:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7177#7177 Switching Connection String at Runtime : Ok this is just a simple question,... http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7155#7155 Author: jmarbutt
Subject: 1860
Posted: 04-Jun-2010 at 11:08pm

Ok this is just a simple question, but how do I switch the connection string at run time based on the user login?]]> Fri, 04 Jun 2010 23:08:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1860&PID=7155#7155