DataEngine for .NET Standard | ComponentOne
C1.DataEngine Assembly / C1.DataEngine Namespace / Workspace Class / join Method / join(String,ExpandoObject,Object) Method
Name of the query. If the name is specified, query result is stored on disk.
Main table to which linked tables are joined.
Columns of the result, and links joining linked tables to the main table.

In This Topic
    join(String,ExpandoObject,Object) Method
    In This Topic
    Creates a join query.
    Syntax
    'Declaration
     
    Public Overloads Function join( _
       ByVal name As String, _
       ByVal mainTable As ExpandoObject, _
       ByVal settings As Object _
    ) As ExpandoObject
    public ExpandoObject join( 
       string name,
       ExpandoObject mainTable,
       object settings
    )

    Parameters

    name
    Name of the query. If the name is specified, query result is stored on disk.
    mainTable
    Main table to which linked tables are joined.
    settings
    Columns of the result, and links joining linked tables to the main table.

    Return Value

    Dynamic object representing the query.
    Remarks
    The dynamic object can be used in queries over the result of this query if such are needed, same way as in table Also, it has a Query property that returns the Query object representing this query. It is used for executing the query: dynamic query1 = workspace.join(...); query1.Query.Execute();
    See Also