Creates a new instance of the SqlDependency class with the default settings.
Assembly: System.Data (in System.Data.dll)
The constructor initializes the SqlDependency object using the default Service Broker service name and time-out. At some point after construction, you must use the AddCommandDependency method to associate one or more commands to this SqlDependency 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