Cache dependency for SQL database changed

[Steffen Loringer]

Hi all,

it seems that the only CacheDependency for an object is time or a file.
I like to renew a dataset in the server-cache once the belonging SQL
database is changed!

Anybody any idea?

Thanx a lot for support!
Steffen

 

[Patrice]

It will be in .NET 2.0.

Meanwhile, you could likely use a trick such as :
http://www.eggheadcafe.com/articles/20030716.aspto
do this with 1.1

Patrice

 

[Eliyahu Goldin]

Steffen,

Consider making an external stored procedure that will write a file and
calling it from a database trigger.

Eliyahu