How to use the SystemWeb.Caching.Cache.Add dependancy object.

[Jensen bredal]

Hello,
I want to cache a table from MS sql server with auto refresh for two hours.

How can this be done in the Addmethod of the Cache object?

Many thanks in advance

JB

 

[Karl Seguin]

Jensen:

Not sure what ur asking. Do you know how to get a dataset? Are you simply
asking how to get a database table into a dataset which can then be cached
(which is sort of what your message asks)

Or, are you asking how you can add a dependency on the database table, much
like you would add a dependency on a file? (which is sort of what your title
is asking).

Karl

 

[Jensen bredal]

Or, are you asking how you can add a dependency on the database table,

much
like you would add a dependency on a file? (which is sort of what your
title
is asking).

Karl

Well i store data into a dataset. I want that data cached. But I want that
cache to change if the source table on the database server get updated.
How can i accomplish this?

Many thanks
JB

 

[Karl Seguin]

Jensen:
This will be a standard feature of ASP.Net 2.0, for now it's doable but with
a bit of effort.

You should find everything you need here:
http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-us/dnaspnet/html/asp11022004.asp

Karl