SqlDependency Constructor (SqlCommand^)
Creates a new instance of the SqlDependency class and associates it with the SqlCommand parameter.
Assembly: System.Data (in System.Data.dll)
Parameters
- command
-
Type:
System.Data.SqlClient::SqlCommand^
The SqlCommand object to associate with this SqlDependency object. The constructor will set up a SqlNotificationRequest object and bind it to the command.
| Exception | Condition |
|---|---|
| ArgumentNullException | The command parameter is NULL. |
| InvalidOperationException | The SqlCommand object already has a SqlNotificationRequest object assigned to its Notification property, and that SqlNotificationRequest is not associated with this dependency. |
Internally, this constructor creates an instance of the SqlNotificationRequest class, and binds it to a SqlCommand object.
Query notifications are supported only for SELECT statements that meet a list of specific requirements. The following table provides links to the Service Broker and Query Notifications documentation in SQL Server Books Online.
SQL Server Books Online
Available since 2.0