SqlDependency.HasChanges Property


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public bool HasChanges { get; }

Property Value

Type: System.Boolean

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.

.NET Framework
Available since 2.0
Return to top