Update Cache with database changes

  • Thread starter Thread starter SMG
  • Start date Start date
S

SMG

Hi there,

I want to update my cached dataset, if there is any change in database. I
know this is possible in case of ASP.Net 2.0 , But how do I execute the same
task with ASP.Net 1.0

As there is need, if any change in database/tables happens then my dataset
should be updated.

Any help on this,

Shailesh
 
Interesting question, but what would happen if your application changed data
in your cached dataset? Would you not lose your changes?

-Frank
 
No, Currently there is no provison for changing the data in cached dataset ,
It is being used only from reading.

:-)
Shailesh
Interesting question, but what would happen if your application changed data
in your cached dataset? Would you not lose your changes?

-Frank
 
Process:
Set up a trigger on the table that may change that the dataset is drwan
from.
Have the trigger write a file to a directory

Use the insert method of the cache object and include a file dependency of
the above filename.

This will expire the cache dataset and require a trip to get fresh data when
needed.

HTH
Harry Simpson
 
Back
Top