Share via

SqlDependency.HasChanges Property


Gets a value that indicates whether one of the result sets associated with the dependency has changed.

 property bool HasChanges { bool get(); };
public bool HasChanges { get; }
member this.HasChanges : bool
Public ReadOnly Property HasChanges As Boolean

Property Value

A Boolean value indicating whether one of the result sets has changed.


If you are not using the OnChange event, you can check the HasChanges property to determine if the query results have changed.

The HasChanges property does not necessarily imply a change in the data. Other circumstances, such as time-out expired and failure to set the notification request, also generate a change event.

Applies to

See also