Updating Cache from Another Table

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

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