SQL Cache Dependancy

During my interview for the next project, I was asked a question. How would you refresh the UI on a page or a cache as soon as the data in the back end database changes (seems to be a very common interview question these days). The best answer that I could come up with at the spur of the moment was the observer pattern.
 
Since there is no way that one could send back a signal from the database to an application saying "I have changed", the only thing I could think of at that moment was to implement the subject in the application itself. I thought at that moment that the subject would be something like a windows service that would keep an eye on the database and when the data changes, it would notify all the observers which in turn would either refresh the cache / UI or ask the right component to do so.
 
I was not convinced though that this is the best solution and did a little research. Well it seems that they have come up with a cleaner solution in ASP.Net 2.0. In fact Dr. Dobb's Jounal had an article about it. ASP.Net 2.0 supplies a class called the SQLCacheDependancy that inherits from the CacheDependancy. Check it out...
 
 

No Comments