Bewerken

Share via


SqlDependency.AddCommandDependency(SqlCommand) Method

Definition

Associates a SqlCommand object with this SqlDependency instance.

public:
 void AddCommandDependency(System::Data::SqlClient::SqlCommand ^ command);
public void AddCommandDependency (System.Data.SqlClient.SqlCommand command);
member this.AddCommandDependency : System.Data.SqlClient.SqlCommand -> unit
Public Sub AddCommandDependency (command As SqlCommand)

Parameters

command
SqlCommand

A SqlCommand object containing a statement that is valid for notifications.

Exceptions

The command parameter is null.

The SqlCommand object already has a SqlNotificationRequest object assigned to its Notification property, and that SqlNotificationRequest is not associated with this dependency.

Remarks

Query notifications are supported only for SELECT statements that meet a list of specific requirements. For more information, see SQL Server Service Broker and Working with Query Notifications.

Applies to

See also