This topic has not yet been rated - Rate this topic

SqlChangeMonitor Class

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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

System.Object
  System.Runtime.Caching.ChangeMonitor
    System.Runtime.Caching.SqlChangeMonitor

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.

  Name Description
Public method SqlChangeMonitor Initializes a new instance of the SqlChangeMonitor class.
Top
  Name Description
Public property HasChanged Gets a value that indicates that the state that is monitored by the ChangeMonitor class has changed. (Inherited from ChangeMonitor.)
Public property IsDisposed Gets a value that indicates that the derived instance of a ChangeMonitor class is disposed. (Inherited from ChangeMonitor.)
Public property UniqueId Gets an identifier for a SqlChangeMonitor instance. (Overrides ChangeMonitor.UniqueId.)
Top
  Name Description
Public method Dispose() Releases all resources that are used by the current instance of the ChangeMonitor class. (Inherited from ChangeMonitor.)
Protected method Dispose(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 method Equals(Object) Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Protected method InitializationComplete Called from the constructor of derived classes to indicate that initialization is finished. (Inherited from ChangeMonitor.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method NotifyOnChanged Called 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 method OnChanged Called by derived classes to raise the event when a dependency changes. (Inherited from ChangeMonitor.)
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Top

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.5, 4

Windows 8 Release Preview, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 SP2, Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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.
Did you find this helpful?
(1500 characters remaining)