SQL Azure doesn't support SqlCacheDependency? is there any replacement for that

Question

How can I implement the SQL caching dependency while SQL Azure doesn't support SqlCacheDependency.

Answer 1

The MSDN article Caching in ASP.NET with the SqlCacheDependency Class describes how SqlCacheDependency is implemented. Starting with SQL Server 2005, the SqlCacheDependency class is able to take advantage of SQL Server Service Broker and Query Notifications. Since SQL Server Service Broker was introduced with SQL Server 2005, the implementation of SqlCacheDependency for earlier versions of SQL Server uses a different technique: polling.

SQL Azure currently does not support SQL Server Service Broker, but it does support polling. Thus, either setup SqlCacheDependency using the polling mechanism or create your own custom CacheDependency.