May 2, 2011 at 9:32 am
I have been trying to get SqlCacheDependency to work in SQL Server Express 2008 and now
SQL Server Express 2008 R2 without success. After reading many articles about what is necessary I still can't seem to invalidate a cache item that is dependent on a SqlCacheDependency.
Broker Enabled is set in my database.
Basically, in my code I do the following,
EnableNotifications in the database,
EnableTableForNotifications in the db table I want to create the SqlCacheDependency on,
create the SqlCacheDependency,
insert/create a new cache item which is dependent on the SqlCacheDependency,
insert a new record into the relevant db table,
check the cache item to see if it is still in existence (valid),
and unfortunately it is.
I have been trying to understand what versions of SQL Server actually support SqlCacheDependency, and would geatly appreciate it if someone could please clarify this.
I am an independent developer and would like to be able to use a free version or at least inexpensive.
I will also need distribution rights as it would become part of any website I build.
Thank you in advance to anyone who would like to respond.
May 12, 2011 at 11:27 am
Any version greater than 2000...from the Remarks section in this article http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx
On all supported versions of SQL Server (Microsoft SQL Server 7.0, Microsoft SQL Server 2000, and SQL Server 2005) the SqlCacheDependency class monitors a specific SQL Server database table.
Your question may get more attention in one of the MSDN .NET Forums:
http://social.msdn.microsoft.com/Forums/en-US/category/netdevelopment
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply