Enum JoinType

Namespace

NextORM.Core

Assembly

nextorm.core.dll

The kind of join connecting a left and right source. Numeric values are part of the plan hash and must stay stable.

public enum JoinType

Extension Methods

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Fields

Anti = 9

ClickHouse LEFT ANTI JOIN: keeps only the left-hand columns, for left rows with no match on the right; the complement of Semi.

Cross = 4

CROSS JOIN: the Cartesian product of both sources; has no ON condition.

CrossApply = 6

CROSS APPLY / CROSS JOIN LATERAL: the right-hand source is evaluated per left-hand row and has no ON condition.

Full = 3

FULL [OUTER] JOIN: keeps every row from both sides, padding where there is no match.

FullCross = 5

A conditionless cross join variant. Renders and evaluates like Cross; kept as a distinct value for callers that need to distinguish it.

Inner = 0

INNER JOIN: keeps only rows that match on both sides.

Left = 1

LEFT [OUTER] JOIN: keeps every left row, padding unmatched right columns with nulls.

OuterApply = 7

OUTER APPLY / LEFT JOIN LATERAL ... ON true: like CrossApply but left-hand rows with an empty right-hand source are preserved with nulls.

Paste = 10

ClickHouse PASTE JOIN: joins the two sources by row position with no ON condition. The result carries the left and right columns side by side and as many rows as the shorter side.

Right = 2

RIGHT [OUTER] JOIN: keeps every right row, padding unmatched left columns with nulls.

Semi = 8

ClickHouse LEFT SEMI JOIN: keeps only the left-hand columns, for left rows that have at least one match on the right. Modelled as a join type rather than a JoinStrictness modifier because it changes the result column set.