PC Review


Reply
Thread Tools Rate Thread

How Cache gets updated using SqlCacheDependency

 
 
Jayender
Guest
Posts: n/a
 
      30th Aug 2006
I read an article :

MSDN help topic. This will get you on the right track.
http://msdn2.microsoft.com/en-us/lib...ependency.aspx

and its really amazing .. I tried it out and got succeeded , now I just
want to know whether is there any possibility to update the cache once
I change the database ,
say: I have inserted the data's ( which is from database to dataset)
into the cache for the first time and now if I run the program again
then the item is displayed from cache.. its great but once I change the
database, the cache gets null and again the query is executed and again
the data's are taken from the database , i need to know whether is
there anything that is updated to the cache without making the cache
null so that the query doesn't execute again .

Like I don't want to update the cache from ASP.net coding like
Cache.Insert("Tablename", Datasetname, dependency);
But I want that to be pused from the database to the cache so that the
cache gets updated.
Is it possible? BIT CURIOUS...

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a thick client equivalant to HttpContext.Current.Cache and SqlCacheDependency? PJ6 Microsoft VB .NET 0 3rd Aug 2008 07:37 PM
SQLCacheDependency not working - Cache item is always null mark4asp Microsoft ASP .NET 1 7th Aug 2007 04:28 PM
SqlCacheDependency - Cache Invalidation wihout result set modification mrashidsaleem@hotmail.com Microsoft ASP .NET 2 10th Jan 2007 07:24 AM
SqlCacheDependency - Cache Invalidation wihout result set modification mrashidsaleem@hotmail.com Microsoft ADO .NET 2 10th Jan 2007 07:24 AM
How Cache gets updated using SqlCacheDependency Jayender Microsoft ASP .NET 0 30th Aug 2006 12:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:10 PM.