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

Package: Korzh.EasyQuery.Db (targets: netstandard2.0)

Assembly: Korzh.EasyQuery.Db.dll

Constructors

Name Type Description
VirtualTable() void Initializes a new instance of the VirtualTable class.

Properties

Name Type Description
Expr string Gets or sets the expression.

Methods

Name Type Description
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.
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.
GetTableTag() string Gets the table class (DB or virtual).
ReadOnePropFromJsonAsync(JsonReader reader, string propName) Task Reads one table's property from JSON (asynchronous way).
ToString() string Returns a System.String that represents the current System.Object.
WritePropertiesToJsonAsync(JsonWriter writer) Task Writes the content of VirtualTable object to JSON (asynchronous way).