The ASP.NET Cache supports invalidation based on key, timestamp, or file dependencies, e.g. file changes and the cache item is invalidated. A frequent question is how to support this from a database, e.g. we're caching a DataSet, or some other reperesentation of data, in the ASP.NET Cache and the table(s) representing that data changes; thus the data in the Cache is no longer valid. This sample shows using some simple code that will automatically wire up a trigger on a table and call an extended stored procedure to call back into the ASP.NET application to invalidate the Cache.
|
