JoinPlan

JoinPlan

public JoinPlan(JoinKind Kind, string Table, string Alias, string ParentAlias, string OnParentColumn, string OnChildColumn)

joinPlan = JoinPlan(Kind, Table, Alias, ParentAlias, OnParentColumn, OnChildColumn)

Description of a single join the translator must add to the FROM-clause for a navigation traversal to be expressible in SQL.

Kind

Inner or left outer join.

Table

Physical table name on the right side of the join.

Alias

Alias assigned to the joined table.

ParentAlias

Alias on the left side that owns the FK column.

OnParentColumn

Column on the parent side used in ON clause.

OnChildColumn

Column on the joined table used in ON clause (typically the PK).

Alias

public string Alias { get; set; }

value = joinPlan.Alias
joinPlan.Alias = value

Alias assigned to the joined table.

Kind

public JoinKind Kind { get; set; }

value = joinPlan.Kind
joinPlan.Kind = value

Inner or left outer join.

OnChildColumn

public string OnChildColumn { get; set; }

value = joinPlan.OnChildColumn
joinPlan.OnChildColumn = value

Column on the joined table used in ON clause (typically the PK).

OnParentColumn

public string OnParentColumn { get; set; }

value = joinPlan.OnParentColumn
joinPlan.OnParentColumn = value

Column on the parent side used in ON clause.

ParentAlias

public string ParentAlias { get; set; }

value = joinPlan.ParentAlias
joinPlan.ParentAlias = value

Alias on the left side that owns the FK column.

Table

public string Table { get; set; }

value = joinPlan.Table
joinPlan.Table = value

Physical table name on the right side of the join.