SqlDependency.AddCommandDependency(SqlCommand) Method

Reference

Definition

Namespace:: System.Data.SqlClient

Assembly:: System.Data.dll

Assembly:: System.Data.SqlClient.dll

Package:: System.Data.SqlClient v4.8.6

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

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.

Applies to

Share via