Method AddJoinItem

Namespace

YndigoBlue.Velocity.Model

Assembly

YndigoBlue.Velocity.dll

AddJoinItem(IFromItem, string, string, IFromItem, string, string, JoinType, JoinOperatorType)

Adds a column-based join item to this Join, with explicit aliases and column names for each side.

public void AddJoinItem(IFromItem parent, string parentAlias, string parentColumnName, IFromItem fromItem, string alias, string columnName, JoinType joinType = JoinType.Inner, JoinOperatorType joinOperatorType = JoinOperatorType.Equals)

Parameters

parent IFromItem

The parent (left-side) table or join.

parentAlias string

Alias for the parent item.

parentColumnName string

Column name on the parent side.

fromItem IFromItem

The child (right-side) table or join.

alias string

Alias for the child item.

columnName string

Column name on the child side.

joinType JoinType

The type of join to perform.

joinOperatorType JoinOperatorType

The comparison operator for the ON condition.

AddJoinItem(IFromItem, string, ISelectItem, IFromItem, string, ISelectItem, JoinType, JoinOperatorType)

Adds a column-based join item to this Join, using explicit ISelectItem references for each side of the condition.

public void AddJoinItem(IFromItem parent, string parentAlias, ISelectItem parentColumn, IFromItem fromItem, string alias, ISelectItem column, JoinType joinType = JoinType.Inner, JoinOperatorType joinOperatorType = JoinOperatorType.Equals)

Parameters

parent IFromItem

The parent (left-side) table or join.

parentAlias string

Alias for the parent item.

parentColumn ISelectItem

The column reference on the parent side.

fromItem IFromItem

The child (right-side) table or join.

alias string

Alias for the child item.

column ISelectItem

The column reference on the child side.

joinType JoinType

The type of join to perform.

joinOperatorType JoinOperatorType

The comparison operator for the ON condition.

AddJoinItem(IFromItem, string, IFromItem, string, JoinType, Function)

Adds a function-based join item to this Join, where a predicate function forms the ON condition.

public void AddJoinItem(IFromItem parent, string parentAlias, IFromItem fromItem, string alias, JoinType joinType, Function function)

Parameters

parent IFromItem

The parent (left-side) table or join.

parentAlias string

Alias for the parent item.

fromItem IFromItem

The child (right-side) table or join.

alias string

Alias for the child item.

joinType JoinType

The type of join to perform.

function Function

The predicate function that forms the ON condition.