SqlNotificationInfo Enumeration
.NET Framework 2.0
Note: This enumeration is new in the .NET Framework version 2.0.
This enumeration provides additional information about the different notifications that can be received by the dependency event handler.
Namespace: System.Data.SqlClient
Assembly: System.Data (in system.data.dll)
Assembly: System.Data (in system.data.dll)
| Member name | Description | |
|---|---|---|
| AlreadyChanged | The SqlDependency object already fired, and new commands cannot be added to it. | |
| Alter | An underlying server object related to the query was modified. | |
| Delete | Data was changed by a DELETE statement. | |
| Drop | An underlying object related to the query was dropped. | |
| Error | An internal server error occurred. | |
| Expired | The SqlDependency object has expired. | |
| Insert | Data was changed by an INSERT statement. | |
| Invalid | A statement was provided that cannot be notified (for example, an UPDATE statement). | |
| Isolation | The statement was executed under an isolation mode that was not valid (for example, Snapshot). | |
| Options | The SET options were not set appropriately at subscription time. | |
| PreviousFire | A previous statement has caused query notifications to fire under the current transaction. | |
| Query | A SELECT statement that cannot be notified or was provided. | |
| Resource | Fires as a result of server resource pressure. | |
| Restart | The server was restarted (notifications are sent during restart.). | |
| TemplateLimit | The subscribing query causes the number of templates on one of the target tables to exceed the maximum allowable limit. | |
| Truncate | One or more tables were truncated. | |
| Unknown | Used when the info option sent by the server was not recognized by the client. | |
| Update | Data was changed by an UPDATE statement. |
The SqlNotificationInfo enumeration is referenced by an instance of the SqlNotificationEventArgs class.
Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Community Additions
ADD
Show: