SqlNotificationInfo Enum
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.
This enumeration provides additional information about the different notifications that can be received by the dependency event handler.
public enum class SqlNotificationInfo
public enum SqlNotificationInfo
[System.Obsolete("Use the Microsoft.Data.SqlClient package instead.")]
public enum SqlNotificationInfo
type SqlNotificationInfo =
[<System.Obsolete("Use the Microsoft.Data.SqlClient package instead.")>]
type SqlNotificationInfo =
Public Enum SqlNotificationInfo
- Inheritance
- Attributes
Name | Value | Description |
---|---|---|
AlreadyChanged | -2 | The |
Unknown | -1 | Used when the info option sent by the server was not recognized by the client. |
Truncate | 0 | One or more tables were truncated. |
Insert | 1 | Data was changed by an INSERT statement. |
Update | 2 | Data was changed by an UPDATE statement. |
Delete | 3 | Data was changed by a DELETE statement. |
Drop | 4 | An underlying object related to the query was dropped. |
Alter | 5 | An underlying server object related to the query was modified. |
Restart | 6 | The server was restarted (notifications are sent during restart.). |
Error | 7 | An internal server error occurred. |
Query | 8 | A SELECT statement that cannot be notified or was provided. |
Invalid | 9 | A statement was provided that cannot be notified (for example, an UPDATE statement). |
Options | 10 | The SET options were not set appropriately at subscription time. |
Isolation | 11 | The statement was executed under an isolation mode that was not valid (for example, Snapshot). |
Expired | 12 | The |
Resource | 13 | Fires as a result of server resource pressure. |
PreviousFire | 14 | A previous statement has caused query notifications to fire under the current transaction. |
TemplateLimit | 15 | The subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit. |
Merge | 16 | Used to distinguish the server-side cause for a query notification firing. |
The SqlNotificationInfo enumeration is referenced by an instance of the SqlNotificationEventArgs class.
מוצר | גירסאות (מיושן) |
---|---|
.NET | 6 (package-provided) (8 (package-provided)) |
.NET Framework | 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 (4.7 (package-provided), 4.7.1 (package-provided), 4.7.2 (package-provided), 4.8 (package-provided)) |
.NET Standard | (2.0 (package-provided)) |
משוב של .NET
.NET הוא פרויקט קוד פתוח. בחר קישור כדי לספק משוב: