Query notification dependency (SqlDependency Class)

7 בJune 2008

Hi Recently I discovered the SqlDependency object which is part of the ADO.NET 2.0. This class is not new (actually it's pretty old - since 2005) but somehow I wasn't aware of it. Introduction MSSQL 2005 contains several new features. One of them is called Service Broker which is in general messaging technology between external and internal processes. I won't go into details but this feature has many uses. The SqlClient namespace in ADO.NET 2.0 contains some new objects that use the Service Broker abilities. One of them is the SqlDependency class which gives the ability to receive notifications when...