SqlNotificationType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Caution
Use the Microsoft.Data.SqlClient package instead.
Describes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.
public enum class SqlNotificationTypepublic enum SqlNotificationType[System.Obsolete("Use the Microsoft.Data.SqlClient package instead.")]
public enum SqlNotificationTypetype SqlNotificationType = [<System.Obsolete("Use the Microsoft.Data.SqlClient package instead.")>]
type SqlNotificationType = Public Enum SqlNotificationType- Inheritance
- Attributes
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.
