SQLDependency: 通过 SQLDependency 监听数据表变化，允许我们对 SourceTable 进行实时监听。当数据更改时自动触发 OnChange 事件。重新开启监听: 数据变化后，必须重新启动监听，以确保程序在后续的变化中继续有效。

有人盯着：通过在百度海洋的搜索，了解到了SqlDependency可以实现这个效果，连接数据库之后，编写查询语句【有注意点，后面讲】，然后使用SqlCommand初始化连接对象和执行的语句，在将SqlD… ...

A <xref:System.Data.SqlClient.SqlDependency> object can be associated with a <xref:System.Data.SqlClient.SqlCommand> in order to detect when query results differ from those originally retrieved. You ...

You shouldn’t over-use SqlDependency or SqlCacheDependency. And now, let’s know the downsides of caching too. The cache object is available to the current application domain only.

Adding a SqlDependency seems like it might fit the bill. Since IE8/IE9 don't support web sockets, we'd still be polling under the covers for those clients, but it would at least provide web ...

SQL SERVER 2005内置支持SQL数据缓存依赖，内置通知传递服务，能够提供更小粒度的数据更改监测，使用和配置简单。 在实现基于服务的SQL数据缓存依赖过程中，需要显式调用SqlDependency.Start来启动接受依赖项更改通知的侦听器 ...