>
>I wonder if I would like to have those "master" tables in memory. What if they are changed during your session is alive?

add a RowVersion (you don't have a server process to get identical times for each client for a Changed_Timestamp)
and just check max(RowVersion) against your cached data.

my 0.002 €

thomas