This documentation is archived and is not being maintained.

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 SqlDependency type exposes the following members.

  NameDescription
Public method SqlDependency Overloaded. Creates a new instance of the SqlDependency class.
Top

  NameDescription
Public method AddCommandDependency Associates a SqlCommand object with this SqlDependency instance.
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the type of the current instance. (Inherited from Object.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method Static member Start Overloaded. Starts the listener for receiving dependency change notifications.
Public method Static member Stop Overloaded. Stops a listener for a connection specified in a previous Start call.
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Top

  NameDescription
Public property HasChanges Gets a value that indicates whether one of the result sets associated with the dependency has changed.
Public property Id Gets a value that uniquely identifies this instance of the SqlDependency class.
Top

  NameDescription
Public event OnChange Occurs when a notification is received for any of the commands associated with this SqlDependency object.
Top
Show: