VirtualTable class

Represents a virtual table. Virtual tables do not correpond to some table in database but are defined through some SQL SELECT statement instead.

public class Korzh.EasyQuery.Db.VirtualTable
    : Table, IComparable<Table>

Properties

Type Name Description
String Expr Gets or sets the expression.

Methods

Type Name Description
String GetFromExpr(DbQueryFormats formats) Gets the full name of the table which is used in FROM clause.
String GetPrimalExpr(DbQueryFormats formats) 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.
String GetSqlExpr(DbQueryFormats formats) Gets the SQL expression that represents the table in WHERE clause.
String GetSqlName(DbQueryFormats formats) Gets the name that represents the table in SQL expressions.
String GetTableTag() Gets the table class (DB or virtual).
void ProcessAttribute(XmlReader reader) Processes one attribute during XML reading.
void ReadOnePropFromJson(JsonReader reader, String propName) Reads one table's property from JSON
Task ReadOnePropFromJsonAsync(JsonReader reader, String propName) Reads one table's property from JSON (asynchronous way).
void SaveAttributes(XmlWriter writer) Saves table properties to System.Xml.XmlWriter.
String ToString() Returns a System.String that represents the current System.Object.
void WritePropertiesToJson(JsonWriter writer) Writes the content of VirtualTable object to JSON
Task WritePropertiesToJsonAsync(JsonWriter writer) Writes the content of VirtualTable object to JSON (asynchronous way).