Configuring Polling SQL Cache Dependencies

Before you can use a Polling SQL cache dependency, you must perform two configuration steps:

  1. You must enable SQL cache dependencies for a database and one or more database tables.
  2. You must configure SQL cache dependencies in your web configuration file.

Let’s examine each of these steps.

Configuring a Database for Polling SQL Cache Dependencies

You can configure a SQL Server database to support Polling SQL cache dependencies by using a class in the Framework named the SqlCacheDependencyAdmin class. This class has the following methods:

• DisableNotifications— Enables you to disable a database for Polling SQL cache dependencies; removes all tables and stored procedures used by Polling SQL cache dependencies. ...

Get ASP.NET 4 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial