DevForce Community Forum : Cache and Related Entity (Lists) http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Cache and Related Entity (Lists) Thu, 15 Oct 2026 15:00:41 -700 Tue, 05 Jul 2011 09:11:22 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2813 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Cache and Related Entity (Lists) : Hi Markus,You can explicitly set... http://www.ideablade.com/forum/forum_posts.asp?TID=2813&PID=11176#11176 Author: sbelini
Subject: 2813
Posted: 05-Jul-2011 at 9:11am

Hi Markus,
You can explicitly set the EntityReferenceStrategy to DoNotLoad:
 
CodeEntity.PropertyMetadata.CodeTyp2List.ReferenceStrategy = new EntityReferenceStrategyEntityReferenceLoadStrategy.DoNotLoad, MergeStrategy.OverwriteChanges);
 
There's a topic in the DevForce Resource Center that will provide you with details.
 
Regards,
   Silvio.
]]> Tue, 05 Jul 2011 09:11:22 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2813&PID=11176#11176 Cache and Related Entity (Lists) : I have a Silverlight application... http://www.ideablade.com/forum/forum_posts.asp?TID=2813&PID=11174#11174 Author: mseeli
Subject: 2813
Posted: 05-Jul-2011 at 2:15am

I have a Silverlight application that can be configured with a large number of codes. Because they play such a important role in the application I load all of these codes at the start of the application into the cache so that later on I don't have to query them asynchronously anymore just to use a code.

I put all the different code types into one table and use inheritance to have different types of codes.
So all my codes inherit from CodeEntity and are in the table CodeEntities in the db.

At the start of the application I get all the entries  CodeEntities and make sure that they are all in the cache.

Some code types are related to each other (1:n relation).

Now I have noticed that when I navigate within these related codes (i.e. CodeTyp1.CodeTyp2List) DevForce re-queries the database even though all of the codes are already in the cache. 

Is this intended? When I set the default query strategy to CacheOnly I can suppress this behavior but I am hesitant to change the default query strategy all the time because I am not clear on the performance cost of such an action. Also I am afraid, that this could cause problems because of the asynchronous scenario (i.e. switching query strategy in one place while another query is still executing)   

Any ideas how to suppress all those needless db accesses?

Thank you  
Markus Seeli
]]> Tue, 05 Jul 2011 02:15:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2813&PID=11174#11174