SqlDependency.AddCommandDependency(SqlCommand) Method

Definition

Namespace:

Microsoft.Data.SqlClient

Assembly:

Microsoft.Data.SqlClient.dll

Package:

Microsoft.Data.SqlClient v5.2.0

Associates a SqlCommand object with this SqlDependency instance.

public:
 void AddCommandDependency(Microsoft::Data::SqlClient::SqlCommand ^ command);

public void AddCommandDependency (Microsoft.Data.SqlClient.SqlCommand command);

member this.AddCommandDependency : Microsoft.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

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.

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.