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
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, CancellationToken ct) | Task | Reads one table's property from JSON (asynchronous way). |
WritePropertiesToJsonAsync(JsonWriter writer, CancellationToken ct) | Task | Writes the content of VirtualTable object to JSON (asynchronous way). |