Edit

SqlDependency.HasChanges Property

  • Reference

Definition

Namespace:
System.Data.SqlClient
Assembly:
System.Data.SqlClient.dll
Assembly:
System.Data.dll
Package:
System.Data.SqlClient v4.8.6

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

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

Property Value

Boolean

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

Remarks

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