tablelink-class
Represents link between two tables
public class Korzh.EasyQuery.Db.TableLink
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. |
| IsObligatory | bool | Gets or sets a value indicating whether this link is obligatory. It means that if two tables participate in a query then this link will be added in any case even if these 2 tables are already joined to some other tables. |
| LinkType | TableLinkType | Gets or sets the type of the link (inner, left, right or full). |
| LnkType | TableLinkType | |
| 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 |
Static Methods
| Name | Type | Description |
|---|---|---|
StrToLinkType(string s) | TableLinkType | Converts text to Korzh.EasyQuery.Db.TableLinkType value. |