table-class

Table class represents one table in a Korzh.EasyQuery.Db.DbModel object

public abstract class Korzh.EasyQuery.Db.Table
    : IComparable<Table>

Assembly: Korzh.EasyQuery.Db.dll

Constructors

Name	Type	Description
Table()	void	Default constructor of the Korzh.EasyQuery.Db.Table class
Table(Table source)	void	Default constructor of the Korzh.EasyQuery.Db.Table class

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.
GetFromExpr(SqlFormats formats)	string	Gets the full name of the table which is used in FROM clause.
GetFullName(bool includeDbName)	string	Gets the full name of the table.
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
GetSchemaName()	string	Gets the schema of the 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, CancellationToken ct = null)	Task	Reads the content of the table from JSON (asynchronous way).
ReadOnePropFromJsonAsync(JsonReader reader, string propName, CancellationToken ct)	Task	Reads one table's property from JSON (asynchronous way).
ToString()	string	Returns a that represents the current .
WritePropertiesToJsonAsync(JsonWriter writer, CancellationToken ct)	Task	Writes table's properties to JSON .
WriteToJsonAsync(JsonWriter writer, CancellationToken ct = null)	Task	Writes table properties to Newtonsoft.Json.JsonWriter object. Calls Korzh.EasyQuery.Db.Table.WritePropertiesToJsonAsync(Newtonsoft.Json.JsonWriter,System.Threading.CancellationToken)procedure to do the job (asynchronous way).

Static Methods

Name	Type	Description
CreateByClass(string className)	Table	Creates Korzh.EasyQuery.Db.Table object the by table class name (db or virtual).