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.
Describes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.
For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient.
public enum class SqlNotificationTypepublic enum SqlNotificationTypetype SqlNotificationType = Public Enum SqlNotificationType- Inheritance
Fields
| Name | Value | Description |
|---|---|---|
| Unknown | -1 | Used when the type option sent by the server was not recognized by the client. For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient. |
| Change | 0 | Data on the server being monitored changed. Use the SqlNotificationInfo item to determine the details of the change. For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient. |
| 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. For new development, use Microsoft.Data.SqlClient. This page documents System.Data.SqlClient. |
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.
