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).