Represents link between two tables
public class Korzh.EasyQuery.Db.TableLink
Package: Korzh.EasyQuery.Db (targets: netstandard2.0)
Assembly: Korzh.EasyQuery.Db.dll
| 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) |
| 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 . |
