Export (0) Print
Expand All

SqlDependency Constructor (SqlCommand)

Creates a new instance of the SqlDependency class and associates it with the SqlCommand parameter.

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

public:
SqlDependency(
	SqlCommand^ command
)

Parameters

command
Type: System.Data.SqlClient::SqlCommand

The SqlCommand object to associate with this SqlDependency object. The constructor will set up a SqlNotificationRequest object and bind it to the command.

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.

Internally, this constructor creates an instance of the SqlNotificationRequest class, and binds it to a SqlCommand object.

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