的SqlDependency VS的SqlCacheDependency

问题描述

这些是什么，当他们要使用的主要区别？我最初的理解是的SqlCacheDependency使用查询，但我读过它没有太多的ASP.NET 2.0。我想知道这是最适合下的ASP.NET Web服务器LINQ查询缓存。这将是ASP.NET 3.5。

解决方案

Query Notification is the underlying technology. SqlNotificationRequest is the ADO.Net client support. SqlDependency is the ADO.Net infrastructure to automate the deployment of temporary objects needed by SqlNotificationRequest. SqlCacheDependency uses SqlDependency to integrate it with the ASP caching infrastructure. See more at The Mysterious Notification.

Note on them work with LINQ. See LinqToCache for a project that leverages Query Notifications with LINQ queries, and also explains why the vast majority of LINQ queries cannot use Query Notifications.

这篇关于的SqlDependency VS的SqlCacheDependency的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！