Table class represents one table in a Korzh.EasyQuery.Db.DbModel object
public abstract class Korzh.EasyQuery.Db.Table
: IComparable<Table>
Package: Korzh.EasyQuery.Db (targets: netstandard2.0)
Assembly: Korzh.EasyQuery.Db.dll
Constructors
Fields
| Name |
Type |
Description |
| Params |
QueryParamList |
The list of parameters associated with this table. |
Properties
| Name |
Type |
Description |
| Alias |
string |
Gets or sets the alias. |
| Category |
TableCategory |
Gets or sets the table category. |
| DBName |
string |
Gets or sets the name of the database. |
| DesignLayout |
string |
Gets or sets the design layout (left, top and width, height of the table window in Data Model Editor). |
| ExtraCondition |
string |
Gets or sets the extra condition. |
| FullName |
string |
Gets the full name of the table. |
| Info |
IDictionary<string, object> |
Stores additional information associated with this entity |
| Links |
TableLinkList |
Gets the links. |
| Priority |
int |
Gets or sets the table's priority. The default value is 0. The table with the biggest priority (among all tables used in this query) will be placed at beginning of FROM clause in the result SQL. |
| SchemaName |
string |
Gets or sets the name of the schema. |
| Store |
TableStore |
Gets the table store of the table. |
Methods
| Name |
Type |
Description |
| CompareToTable(Table tbl) |
int |
Compares the current table with another table alphabetically. |
| ComposeAlias(SqlFormats formats) |
string |
Composes the alias. |
| GetCalcAlias() |
string |
Gets the calculated alias (used when the "alias" field is empty) |
| GetFromExpr(SqlFormats formats) |
string |
Gets the full name of the table which is used in FROM clause. |
| GetPrimalExpr(SqlFormats formats) |
string |
Gets the "primal" table expression. Usually it's the name this table is referenced by in the DB. However, for a virtual table it's simply its expression. |
| GetRank() |
int |
Gets table's rank. It represents the number of links which come out from this table |
| GetSqlExpr(SqlFormats formats) |
string |
Gets the SQL expression that represents the table in WHERE clause. |
| GetSqlName(SqlFormats formats) |
string |
Gets the name that represents the table in SQL expressions. |
| GetTableName() |
string |
Gets the name of the table. |
| GetTableTag() |
string |
Gets the table Tag (class): DB or virtual. |
| GetWeight() |
int |
|
NeedQuote(string s) |
bool |
Gets a value indicating whether string should be quoted |
QuoteIfNecessary(string s, SqlFormats formats) |
string |
Puts quotes around identifier if necessary. |
ReadFromJsonAsync(JsonReader reader) |
Task |
Reads the content of the table from JSON (asynchronous way). |
ReadOnePropFromJsonAsync(JsonReader reader, string propName) |
Task |
Reads one table's property from JSON (asynchronous way). |
WritePropertiesToJsonAsync(JsonWriter writer) |
Task |
Writes table's properties to JSON . |
WriteToJsonAsync(JsonWriter writer) |
Task |
Writes table properties to Newtonsoft.Json.JsonWriter object. Calls Korzh.EasyQuery.Db.Table.WritePropertiesToJsonAsync(Newtonsoft.Json.JsonWriter)procedure to do the job (asynchronous way). |
Static Methods
