This documentation is archived and is not being maintained.

SqlChangeMonitor Class

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.)
Protected methodDispose(Boolean)Releases all managed and unmanaged resources and any references to the ChangeMonitor instance. This overload must be implemented by derived change-monitor classes. (Inherited from ChangeMonitor.)
Public methodEquals(Object)Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public methodGetHashCodeServes as a hash function for a particular type. (Inherited from Object.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Protected methodInitializationCompleteCalled from the constructor of derived classes to indicate that initialization is finished. (Inherited from ChangeMonitor.)
Protected methodMemberwiseCloneCreates a shallow copy of the current Object. (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.)
Protected methodOnChangedCalled by derived classes to raise the event when a dependency changes. (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

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

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