Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlChangeMonitor Class

.NET Framework 4.6 and 4.5

Provides change monitoring for SQL Server databases. This class cannot be inherited.


Namespace:  System.Runtime.Caching
Assembly:  System.Runtime.Caching (in System.Runtime.Caching.dll)

public sealed class SqlChangeMonitor : ChangeMonitor

The SqlChangeMonitor type exposes the following members.

Public methodSqlChangeMonitorInitializes a new instance of the SqlChangeMonitor class.

Public propertyHasChangedGets a value that indicates that the state that is monitored by the ChangeMonitor class has changed. (Inherited from ChangeMonitor.)
Public propertyIsDisposedGets a value that indicates that the derived instance of a ChangeMonitor class is disposed. (Inherited from ChangeMonitor.)
Public propertyUniqueIdGets an identifier for a SqlChangeMonitor instance. (Overrides ChangeMonitor.UniqueId.)

Public methodDispose()Releases all resources that are used by the current instance of the ChangeMonitor class. (Inherited from ChangeMonitor.)
Public methodEquals(Object)Determines whether the specified object is equal to the current object. (Inherited from Object.)
Public methodGetHashCodeServes as the default hash function. (Inherited from Object.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodNotifyOnChangedCalled by Cache implementers to register a callback and notify an ObjectCache instance through the OnChangedCallback delegate when a dependency has changed. (Inherited from ChangeMonitor.)
Public methodToStringReturns a string that represents the current object. (Inherited from Object.)

The SqlChangeMonitor class wraps the ADO.NET SqlDependency class and adds change monitoring for SQL Server-based dependencies. Therefore, the SqlChangeMonitor class serves as a bridge between the ADO.NET SqlDependency object and the System.Runtime.Caching namespace.

.NET Framework

Supported in: 4.6, 4.5, 4

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
© 2015 Microsoft