Table class represents one table in a Korzh.EasyQuery.Db.DbModel object
public abstract class Korzh .EasyQuery.Db.Table
Package: Korzh.EasyQuery.Db
(targets: netstandard2.0
)
Assembly: Korzh.EasyQuery.Db.dll
Name Type Description Params QueryParamList The list of parameters associated with this table.
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.
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).