Skip to content

TableLink class

Represents link between two tables

public class Korzh.EasyQuery.Db.TableLink
TypeNameDescription
StringConditionExprGets or sets the expression of link condition. This expression will be used if Korzh.EasyQuery.Db.TableLink.Conditions list is empty.
ConditionListConditionsGets list of linking conditions.
LinkTypeLnkTypeGets or sets the type of the link (inner, left, right or full).
BooleanQuoteFieldsGets or sets a value indicating whether field names in link conditions should be quoted in SQL expressions.
TableTable1Gets or sets the first table of the link.
TableTable2Gets or sets the second table of the link.
TypeNameDescription
ConditionAddCondition(LinkCondType condType, String expr1, String expr2, String operation)Adds the link condition by two expressions and operation.
voidAddConditionExpr(String condExpr)
voidClearParent()Clears the reference to parent list.
BooleanContainsTable(Table table)Returns true if the table passed in parameter participates in this link
TableLinkCopyFrom(TableLink link)Gets or sets a value indicating whether field names in link conditions should be quoted in SQL expressions.
voidEnsureExistenceInTables()Ensures the existence in tables.
StringGetSqlExpr(DbQueryFormats formats)Gets the SQL expression of the link
voidRemoveFromTables()Removes link reference from linked tables.
voidSetParent(TableLinkList parent)Sets the reference to parent list.
voidSetTable1Silently(Table tbl1)
voidSetTable2Silently(Table tbl2)
StringToString()Returns a that represents the current .
TypeNameDescription
LinkTypeStrToLinkType(String s)Converts text to Korzh.EasyQuery.Db.TableLink.LinkType value.