Dela via


SqlNotificationType Enum

Definition

Describes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.

public enum class SqlNotificationType
public enum SqlNotificationType
type SqlNotificationType = 
Public Enum SqlNotificationType
Inheritance
SqlNotificationType

Fields

Name Value Description
Unknown -1

Used when the type option sent by the server was not recognized by the client.

Change 0

Data on the server being monitored changed. Use the SqlNotificationInfo item to determine the details of the change.

Subscribe 1

There was a failure to create a notification subscription. Use the SqlNotificationEventArgs object's SqlNotificationInfo item to determine the cause of the failure.

Remarks

The SqlNotificationType enumeration is referenced by an instance of the SqlNotificationEventArgs class. This information is provided when a notification event is fired with the SqlDependency class.

Applies to