Stack Overflow
Stack Overflow

Questions tagged [sqlcachedependency]

Establishes a relationship between an item stored in an ASP.NET application's Cache object and either a specific SQL Server database table or the results of a SQL Server 2005 query

System.Object
. System.Web.Caching.CacheDependency
. . System.Web.Caching.SqlCacheDependency

Namespace: System.Web.Caching
Assembly: System.Web (in System.Web.dll)

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. When the table changes, items associated with the table are removed from the Cache, and a new version of the item is added to the Cache.

http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx

78 questions
0
votes
1 answer

In ASP.Net web farm is database dependent Caching a good approach?

I was looking at using data caching with database dependency for a web farmed ASP.Net app. So each web server in the web farm would automatically refresh its Cache value as soon as the database value changes. This would appear to keep all Cache…
Sunil
  • 20,653
  • 28
  • 112
  • 197
0
votes
1 answer

Enterprise Library SqlCacheDependency

I am working with Enterprise Library Application Block in my application and need to use SqlCacheDependency, but Caching block does not have SqlDependency Expiration available, Tried to search, found a post with broken link (david hyden), there must…
Milan Solanki
  • 1,207
  • 4
  • 25
  • 48
0
votes
2 answers

SqlNotificationEvent notify multiple times for even single insert in database

SqlNotificationEvent notify multiple times for even single insert in database. Even for single insert/update/delete in table the event notify for several time with e.Type == SqlNotificationType.Change, can anyone help why this happens. It should…
Shivu
  • 11
  • 4
1 2 3 4 5
6