问题描述
我怎样才能实现SQL缓存依赖，而SQL Azure不支持的SqlCacheDependency
How can I implement the SQL caching dependency while SQL Azure doesn't support SqlCacheDependency.
推荐答案
MSDN文章的介绍如何的SqlCacheDependency 实施。
从SQL Server 2005开始，的SqlCacheDependency 类是能够采取的SQL Server Service Broker和查询通知的优势。
由于SQL Server的服务代理与SQL Server 2005引入，的SqlCacheDependency 为SQL Server早期版本的实现使用不同的技术：轮询
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中目前不支持SQL Server Service Broker的，但它不支持轮询。
因此，无论是设置的SqlCacheDependency 使用轮询机制或创建自己的自定义的CacheDependency 。
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.
这篇关于SQL Azure不支持的SqlCacheDependency？有没有替代的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！