Using Polling SQL Cache Dependencies with Page Output Caching
After you configure Polling SQL cache dependencies, you can use a SQL dependency with Page Output Caching. For example, the page in Listing 29.42 is output cached until you modify the Movies database table.
The page in Listing 29.42 includes an
<%@ OutputCache %> directive with a
SqlDependency attribute. The value of the
SqlDependency attribute is the name of the database enabled for SQL dependencies in the web configuration file, followed by the name of a database table.
If you open the page in Listing 29.42 in your browser and click your ...