SqlDependency Members
The SqlDependency object represents a query notification dependency between an application and an instance of SQL Server 2005. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler.
The following tables list the members exposed by the SqlDependency type.
| Name | Description | |
|---|---|---|
 | HasChanges | Gets a value that indicates whether one of the result sets associated with the dependency has changed. |
| | Id | Gets a value that uniquely identifies this instance of the SqlDependency class. |
(see also
Protected Methods
)
Top
| Name | Description | |
|---|---|---|
 | AddCommandDependency | Associates a SqlCommand object with this SqlDependency instance. |
| | Equals | Overloaded. Determines whether two Object instances are equal. (Inherited from Object.) |
| | GetHashCode | Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
| | GetType | Gets the Type of the current instance. (Inherited from Object.) |
 | ReferenceEquals | Determines whether the specified Object instances are the same instance. (Inherited from Object.) |
| | Start | Overloaded. Starts the listener for receiving dependency change notifications. |
| | Stop | Overloaded. Stops a listener for a connection specified in a previous Start call. |
| | ToString | Returns a String that represents the current Object. (Inherited from Object.) |
| Name | Description | |
|---|---|---|
 | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
| | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
Reference
SqlDependency ClassSystem.Data.SqlClient Namespace
