SqlDependency.AddCommandDependency(SqlCommand) Method

Definition

Namespace:

System.Data.SqlClient

Assembly:

System.Data.SqlClient.dll

Package:

System.Data.SqlClient v4.8.6

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.

See also

• Using Query Notifications
• ADO.NET Overview