SqlCacheDependency - strange problem

[Jordan]

I am caching a list of data with SqlServer2005 and an
SqlCacheDepende ncy. 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

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

RE: SqlCacheDepende ncy - strange problem

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

"Jordan" wrote:

I am caching a list of data with SqlServer2005 and an
SqlCacheDepende ncy. 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
>