ComponentOne FlexPivot for WinForms
join(String,ExpandoObject,Object) Method

C1.DataEngine.4 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 resut, and links joining linked tables to the main table.
Creates a join query.
Syntax
'Declaration
 
Public Overloads Function join( _
   ByVal name As System.String, _
   ByVal mainTable As System.Dynamic.ExpandoObject, _
   ByVal settings As System.Object _
) As System.Dynamic.ExpandoObject
public System.Dynamic.ExpandoObject join( 
   System.string name,
   System.Dynamic.ExpandoObject mainTable,
   System.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 resut, 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

Reference

Workspace Class
Workspace Members
Overload List