-
dotnet-api
-
C1.DataEngine Assembly
-
C1.DataEngine
-
Classes
- BaseTable
- Column
- ColumnCondition
- ColumnCopy
- ColumnDerived
- ColumnOp
- ColumnOpCustom
- ColumnOpCustomBase
- ColumnOpCustomGroup
- Columns
- CondValue
- CondValues
- Condition
- Connector
- Converter
- DbConnector
- JoinColumns
- JoinQuery
- LicenseManager
- ObjectConnector<T>
- Op
- Query
- Table
- UnsupportedTypeException
- Values
- Workspace
- Enums
- Interfaces
- Delegates
-
Classes
-
C1.DataEngine
- C1.PivotEngine Assembly
- C1.Win.FlexPivot.8 Assembly
-
C1.DataEngine Assembly
- dotnet-framework-api
C1.DataEngine.Workspace.join
join Method
join(string, ExpandoObject, object)
Creates a join query.
Declaration
public ExpandoObject join(string name, ExpandoObject mainTable, object settings)Parameters
| Type | Name | Description |
|---|---|---|
| string | name | Name of the query. If the name is specified, query result is stored on disk. |
| ExpandoObject | mainTable | Main table to which linked tables are joined. |
| object | settings | Columns of the result, and links joining linked tables to the main table. |
Returns
| Type | Description |
|---|---|
| ExpandoObject | 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(string) 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();join(ExpandoObject, object)
Creates a join query.
Declaration
public ExpandoObject join(ExpandoObject mainTable, object settings)Parameters
| Type | Name | Description |
|---|---|---|
| ExpandoObject | mainTable | Main table to which linked tables are joined. |
| object | settings | Columns of the result, and links joining linked tables to the main table. |
Returns
| Type | Description |
|---|---|
| ExpandoObject | 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(string) 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();