dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDependency Class / AddCommandDependency Method / AddCommandDependency(MySqlCommand,MySqlDependencyCheckType) Method
The MySqlCommand object to watch for.
The check method to use for checking tables for changes. See MySqlDependencyCheckType for more details.

In This Topic
    AddCommandDependency(MySqlCommand,MySqlDependencyCheckType) Method
    In This Topic
    Associates a MySqlCommand object with this MySqlDependency instance and specifies the check method to use.
    Syntax
    'Declaration
     
    Public Overloads Sub AddCommandDependency( _
       ByVal command As MySqlCommand, _
       ByVal checkType As MySqlDependencyCheckType _
    ) 
    public void AddCommandDependency( 
       MySqlCommand command,
       MySqlDependencyCheckType checkType
    )

    Parameters

    command
    The MySqlCommand object to watch for.
    checkType
    The check method to use for checking tables for changes. See MySqlDependencyCheckType for more details.
    Remarks

    You can associate more than one MySqlCommand objects. Every MySqlCommand object can be associated with a single MySqlDependency instance.

    MySqlDependency analyzes the CommandText property of every MySqlCommand object and extracts names of the tables to watch basing on the FROM clause of the SELECT statements.

    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