SqlDependency.AddCommandDependency(SqlCommand) Method
Definition
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 -> unitPublic Sub AddCommandDependency (command As SqlCommand)Parameters
- command
- SqlCommand
A SqlCommand object containing a statement that is valid for notifications.
Exceptions
The command parameter is null.
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.
