SqlCacheDepende ncy works for a couple of minutes

[Yosi]

Hi,

I have a wierd problem about the SqlCacheDepende ncy class. It just
works for a couple of minutes. After 2 minutes or more, the cache does
not expire anymore. I'm using SQL Server 2005 as database.

Here is the code:

private string getTime()

{

string time = (string)Cache["KEY"];

if (time == null)

{
SqlConnection sqlConnection = new
SqlConnection(@ "Server=BIZYUSU F\SQL2005;Datab ase=Deneme2;Use r
Id=sa;Password= ;");

SqlCommand command = new SqlCommand(@"se lect KOLON1 from
dbo.CACHE_DENEM E3", sqlConnection);

sqlConnection.O pen();
SqlCacheDepende ncy dependency = new SqlCacheDepende ncy(command);
time = System.DateTime .Now.ToString() ;

Cache.Insert("K EY", time, dependency);

command.Execute Reader();

sqlConnection.C lose();

}

return time;

}
When there is no activity for 2-3 minutes , the cache does not expire
anymore. Even that I insert a record to the CACHE_DENEME3 table, the
page reads from the cache.
Am I the only person, encountering this issue ?

[Duncan Smith [MSFT]]

"Yosi" wrote:

I have a wierd problem about the SqlCacheDepende ncy class. It just
works for a couple of minutes. After 2 minutes or more, the cache does
not expire anymore. I'm using SQL Server 2005 as database.

When there is no activity for 2-3 minutes , the cache does not expire
anymore. Even that I insert a record to the CACHE_DENEME3 table, the
page reads from the cache.
Am I the only person, encountering this issue ?

Yosi,

Microsoft has release a hotfix that addresses this problem:

http://support.microsoft.com/kb/913364/EN-US/

=============== =====
Duncan Smith [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.