SqlNotificationSource Enumeration
.NET Framework 3.0
Indicates the source of the notification 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 | |
|---|---|---|
| Client | A client-initiated notification occurred, such as a client-side time-out or as a result of attempting to add a command to a dependency that has already fired. | |
| Data | Data has changed; for example, an insert, update, delete, or truncate operation occurred. | |
| Database | The database state changed; for example, the database related to the query was dropped or detached. | |
| Environment | The run-time environment was not compatible with notifications; for example, the isolation level was set to snapshot, or one or more SET options are not compatible. | |
| Execution | A run-time error occurred during execution. | |
| Object | A database object changed; for example, an underlying object related to the query was dropped or modified. | |
| Owner | Internal only; not intended to be used in your code. | |
| Statement | The Transact-SQL statement is not valid for notifications; for example, a SELECT statement that could not be notified or a non-SELECT statement was executed. | |
| System | A system-related event occurred. For example, there was an internal error, the server was restarted, or resource pressure caused the invalidation. | |
| Timeout | The subscription time-out expired. | |
| Unknown | Used when the source option sent by the server was not recognized by the client. |
The SqlNotificationSource enumeration is referenced by an instance of the SqlNotificationEventArgs class.
Windows 98, Windows Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.Community Additions
ADD
Show: