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