TableLink class

Represents link between two tables

public class Korzh.EasyQuery.Db.TableLink

Package: Korzh.EasyQuery.Db (targets: netstandard2.0)

Assembly: Korzh.EasyQuery.Db.dll

Constructors

Name Type Description
TableLink() void Initializes a new instance of the Korzh.EasyQuery.Db.TableLink class.

Properties

Name Type Description
ConditionExpr string Gets or sets the expression of link condition. This expression will be used if Korzh.EasyQuery.Db.TableLink.Conditions list is empty.
Conditions TableLink.ConditionList Gets list of linking conditions.
IsEnabled bool Determines whether the link can be used on query building.
LnkType TableLinkType Gets or sets the type of the link (inner, left, right or full).
Model DbModel
QuoteFields bool Gets or sets a value indicating whether field names in link conditions should be quoted in SQL expressions.
Table1 Table Gets or sets the first table of the link.
Table2 Table Gets or sets the second table of the link.
UseHash bool Gets or sets value indicating wether database should use hash join algorithm (experimental feature)

Methods

Name Type Description
AddCondition(LinkCondType condType, string expr1, string expr2, string operation) TableLink.Condition Adds the link condition by two expressions and operation.
ContainsTable(Table table) bool Returns true if the table passed in parameter participates in this link
CopyFrom(TableLink link) TableLink Copy information from other link
GetSqlExpr(SqlFormats formats) string Gets the SQL expression of the link
SwitchTables(bool changeLinkTypeAccordingly = False) void Switches the tables that participate in the link. Table1 become Table2 and vice versa. So, the default direction of the link is changed.
ToString() string Returns a that represents the current .

Static Methods

Name Type Description
StrToLinkType(string s) TableLinkType Converts text to Korzh.EasyQuery.Db.TableLinkType value.