Configuring Push SQL Cache Dependencies
You must perform two configuration steps to enable Push SQL cache dependencies:
- Configure your database by enabling the SQL Server Service Broker.
- 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.