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

In This Topic
    OnChange Event
    In This Topic
    Occurs when a notification is received for any of the commands associated with this PgSqlDependency object.
    Syntax
    'Declaration
     
    Public Event OnChange As OnChangeEventHandler
    public event OnChangeEventHandler OnChange
    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