DevForce Community Forum : DataSourceKey question http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : DataSourceKey question Sun, 12 Apr 2026 23:35:39 -700 Wed, 14 Dec 2011 09:50:29 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3151 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ DataSourceKey question : we encountered a similar problem... http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12237#12237 Author: rickadams
Subject: 3151
Posted: 14-Dec-2011 at 9:50am

we encountered a similar problem where we needed to connect to multiple databases using the same EntityModels. Our solution was to divide up the connection string and the metadata string into a DataResource Table. We looked up the metadata using the keyName and the database connection using the keyExtension. Our DataKeyResolver then concatenated the two to return the correct connection string. This means that we only have 1 metadata string per EntityModel and however many database connections we needed ( in our case 4). This also means we can also handle generating the connectionstrings for DEV, PROD and TEST databases without having an insane number of entries in the web.config ( we have a web farm of 6 servers so imaging the maintenance ). I can send you code if you wish. Hope this helps]]> Wed, 14 Dec 2011 09:50:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12237#12237 DataSourceKey question : That kinda matches what I have... http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12233#12233 Author: midnit
Subject: 3151
Posted: 13-Dec-2011 at 12:31pm

That kinda matches what I have played with but it just feels wonky. Thank you for confirming]]> Tue, 13 Dec 2011 12:31:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12233#12233 DataSourceKey question : You have 27 EDMXes in... http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12232#12232 Author: kimj
Subject: 3151
Posted: 13-Dec-2011 at 12:11pm

You have 27 EDMXes in your application!?

Well ... the GetKey method on the resolver is called with the data source key name and extension.  The resolver can also be exported by composition context, so you could have different resolvers for different contexts.  You also know that the metadata names will always be based on the EDMX name, so for example a NorthwindIB.edmx would use a metadata string like

   metadata=res://*/NorthwindIB.csdl|res://*/NorthwindIB.ssdl|res://*/NorthwindIB.msl;

So you might be able to use the data source key + extension either as your model name, or as a key to your own dictionary of model names.
 
That's about all I can come up with.  :)
 

 

]]> Tue, 13 Dec 2011 12:11:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12232#12232 DataSourceKey question : We have a bunch of different models... http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12219#12219 Author: midnit
Subject: 3151
Posted: 12-Dec-2011 at 9:46am

We have a bunch of different models and each one hits the same database so technically we only have one or two connection strings...but we currently have an EdmKey defined for each model since it includes the metadata.
 
So right now we have 27 EdmKeys in the web.config when we could just have 2 if you threw out the metadata. I have tried a few different ways of doing that with no real "success" as each "successful" solution required even more work/maintenance.
 
In trying IDataSourceKeyResolver I see that it is of no help in this area - unless there is a way to programmatically tease the metadata text out of the model but I assume that its not possible as we don't know the context?
 
Suggestions needed :)
]]> Mon, 12 Dec 2011 09:46:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3151&PID=12219#12219