Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlDependency.AddCommandDependency Method

Associates a SqlCommand object with this SqlDependency instance.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public void AddCommandDependency(
	SqlCommand command
)

Parameters

command
Type: System.Data.SqlClient.SqlCommand

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

ExceptionCondition
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.

Query notifications are supported only for SELECT statements that meet a list of specific requirements. The following table provides links to the Service Broker and Query Notifications documentation in SQL Server Books Online.

SQL Server Books Online

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft