dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlDependency Class / OnChange Event

OnChange Event
Occurs when a notification is received for any of the commands associated with this PgSqlDependency object.
Syntax
'Declaration
 
Public Event OnChange As OnChangeEventHandler
 
Event Data

The event handler receives an argument of type PgSqlTableChangeEventArgs containing data related to this event. The following PgSqlTableChangeEventArgs properties provide information specific to this event.

PropertyDescription
Gets PgSqlCommand object associated with the table that was modified on the server.  
Returns the string that was passed to the NOTIFY command in a trigger as a second parameter.  
Gets name of the table that was modified on the server.  
Remarks

Keep in mind that this event is fired not when the tables are actually modified, but when PgSqlDependency checks for modifications.

The event invokes a OnChangeEventHandler with an argument of type PgSqlTableChangeEventArgs.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also