SqlDependency.AddCommandDependency(SqlCommand) Method

Reference

Definition

Namespace:: System.Data.SqlClient

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Package:: System.Data.SqlClient v4.9.0

Source:: System.Data.SqlClient.notsupported.cs

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

Product	Versions
.NET	6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided)
.NET Framework	2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0 (package-provided)

Share via