how do i achive asp.net data dependancy caching?

Question

I have asp.net web applications as well as console apps that run on a schedule. both types have a lot of functionality that is data driven and it would be great to cache the items.

but i need the apps to have access to real time SQL table data, so the cache should be refreshed when ever the SQL table data is changed.

i think i recall some talks about a new data dependency cache advertised in .net 3.5 or .net 4.0 but cant find anything on it now that i need it.

does this functionality exist out of the box with .net (what version)

if not how can i implement something like this. i would hope there is boiler plate code i can reuse since this is somethign millions of apps can benefit from.

Answer 1

http://www.asp.net/data-access/tutorials/using-sql-cache-dependencies-cs