Cache

[Rocky Moore]

Was wondering if there is some method to invalidate a cached dataset (or
datatable) based on dirty data in the database other than having to fill the
dataset on every call. Does anyone know a method or a third party tool that
will do that?

--
Rocky Moore
www.HintsAndTips.com / Now with GMail Queue - Share your tips - Earn rewards
www.MyQuickPoll.com / 2004 Election poll ID #33
www.GotTheAnswerToSpam.com / Block virtually all spam email
www.RJSoft.com/Products/RJContentPanel/ - Free web user template content
control!

 

[Shiva]

Check out this article:
http://msdn.microsoft.com/msdnmag/issues/03/04/WickedCode/default.aspx

Was wondering if there is some method to invalidate a cached dataset (or
datatable) based on dirty data in the database other than having to fill the
dataset on every call. Does anyone know a method or a third party tool that
will do that?

--
Rocky Moore
www.HintsAndTips.com / Now with GMail Queue - Share your tips - Earn rewards
www.MyQuickPoll.com / 2004 Election poll ID #33
www.GotTheAnswerToSpam.com / Block virtually all spam email
www.RJSoft.com/Products/RJContentPanel/ - Free web user template content
control!

 

[Joe Fallon]

The file dependency mechanism works but has security (and scalability?)
issues.)

You can implement a database cache dependency in ASP.Net 1.1 if you use
Polling.
http://www.eggheadcafe.com/articles/20040607.asp

Note my comments at the bottom of this article. If you need it to work in a
web farm.
I have it running in an app and it works just fine.

In 2.0 there should be a Publish/Subscribe model which will be less resource
intensive.