http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Updating Cache from Another Table Sat, 11 Apr 2026 10:55:57 -700 Wed, 09 Jun 2010 18:34:31 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1868 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7238#7238 Author: GregD
Subject: 1868
Posted: 09-Jun-2010 at 6:34pm

There is a RefetchEntitiesAsync() method on the EntityManager that takes an EntityKeyList, and there's quite a bit of metadata available on any Entity, including what the EntityKey is, so very likely you can abstract it.]]> Wed, 09 Jun 2010 18:34:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7238#7238 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7188#7188 Author: jmarbutt
Subject: 1868
Posted: 07-Jun-2010 at 5:02pm

Well sort of, I guess was trying to figure out the easiest way to tell the other table to update the entity. That way when I add tables down the road it will update with out a special case.

The only way I see it is to do something like this:

switch TableName

case "People"
var query = from p in entities.people where p.id = id
select p;

case "Orders"
var query = from p in entities.orders where p.id = id
select p;
....
....
end switch


I was looking for a better way if that is possible]]> Mon, 07 Jun 2010 17:02:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7188#7188 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7187#7187 Author: GregD
Subject: 1868
Posted: 07-Jun-2010 at 4:29pm

I'm not sure I understand what the problem is you're trying to solve. If you have an Audit entity, and you retrieve instances of it using the query you propose, then you'll have all the information you need, won't you? Your collection of Audit entities is the record of all entities that need to be refreshed in cache (provided they're there to begin with).
]]> Mon, 07 Jun 2010 16:29:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7187#7187 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7178#7178 Author: jmarbutt
Subject: 1868
Posted: 07-Jun-2010 at 1:02pm

We have a large application with about 300 tables, and one audit table. The audit table contains the Id in the other tables as well as an UpdateDate.

I would like to be able to make one call to the AuditTable like:

var query = from a in MyEntities.AuditTable where UpdateDate > LastUpdate

And then be able to figure out what other entities need to be updated from that result set. What is the easiest way to do this? I don't want to have write special cases for each of these tables so what is the ideal way?

Edited by jmarbutt - 07-Jun-2010 at 1:41pm]]> Mon, 07 Jun 2010 13:02:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1868&PID=7178#7178