I suspect you're over engineering this a bit. A good cache manager will handle completely (or mostly facilitate) the monitoring and re-caching of data that has changed. In terms of .NET there are technological alignments with SQL Server. What's the application language?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato