dotConnect for Salesforce Marketing Cloud Documentation
Devart.Data.ExactTarget Namespace / ExactTargetCommandBuilder Class / DeriveParameters Method
The ExactTargetCommand referencing the SQL statement for which the parameter information is to be derived. The derived parameters will be populated into the ExactTargetCommand.Parameters collection of this command.

In This Topic
    DeriveParameters Method
    In This Topic
    Populates the specified ExactTargetCommand object's ExactTargetCommand.Parameters collection with parameter information for the SQL statement specified in the CommandText.
    Syntax
    'Declaration
     
    Public Shared Sub DeriveParameters( _
       ByVal command As ExactTargetCommand _
    ) 
    public static void DeriveParameters( 
       ExactTargetCommand command
    )

    Parameters

    command
    The ExactTargetCommand referencing the SQL statement for which the parameter information is to be derived. The derived parameters will be populated into the ExactTargetCommand.Parameters collection of this command.
    Remarks
    DeriveParameters overwrites any existing parameter information for the ExactTargetCommand.

    DeriveParameters requires an extra call to the data server to obtain the information. If the parameter information is known in advance, it is more efficient to populate the parameters collection by setting the information explicitly.

    For more information, see "Using Stored Procedures with a Command" in the Microsoft .NET Framework SDK documentation.

    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