Configuring Push SQL Cache Dependencies

You must perform two configuration steps to enable Push SQL cache dependencies:

  1. Configure your database by enabling the SQL Server Service Broker.
  2. Configure your application by starting the notification listener.

In this section, you learn how to perform both of these configuration steps.

Warning

Unfortunately, when a Push SQL cache dependency fails, it fails silently, without adding an error message to the Event Log. This makes the situation especially difficult to debug. I recommend that after you make the configuration changes discussed in this section that you restart both your web server and database server.

Configuring a Database for Push SQL Cache Dependencies

Before you can use Push SQL cache ...

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.