SqlCacheDependency - strange problem

[Jordan]

I am caching a list of data with SqlServer2005 and an
SqlCacheDependency. The data is used on a CRUD page (to add, update
and delete "owners"). For some reason I have to change the data twice
before the cache is invalidated. Example: I update an owner's name --
the cached data is not invalidated. Then I add a new owner, the cache
is invalidated, and both changes are reflected in the list at the same
time. Or, I update a row and the data is not invalidated. Then I
updated it again and the data is invalidated and refreshed.

Any ideas why?

Jordan

 

[Peter Bromberg [C# MVP]]

Can you post a "Short but complete" code sample to enable readers to see what
you're doing?
--
--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com