Enabling SQL Cache Dependency within your .Net Application
Thursday, November 6, 2008 14:11Posted in category HowTo
No Comments
This one’s short and sweet … add the following snippet to your web.config file (within the configuration > system.web > pages node):
1: <caching>
2: <sqlCacheDependency enabled="true"/>
3: </caching>
Also, don’t forget to add the following property and value to the desired providers node:
1: sqlCacheDependency="CommandNotification"
Finally, make sure your SQL Server has the Service Broker feature enabled.
(You can read more about SQL Cache Dependency here)
You can follow any responses to this entry through the RSS 2.0 feed.
You can skip to the end and leave a response. Pinging is currently not allowed.