DbQuery class

Represents query for building SQL command

public class Korzh.EasyQuery.Db.DbQuery
    : Query

Properties

Type Name Description
TableList ExtraTables Gets the list of "extra" tables (the tables which will be included into result query by user request).
NoPathResolution NoPathResolution Get or set the type of reaction for the situation when two tables have no path between them
SqlExtras Options Gets the Korzh.EasyQuery.Db.SqlExtras object which defines some extra clauses of generated query.
IEnumerable<Column> ResultColumns Gets the full list of columns which will be returned in result query. It equals to Columns list if it's not empty. Otherwise - it's an array of all fields from all tables taking part in this query (like SELECT * in SQL).

Events

Type Name Description
CondSqlGenEventHandler CondSqlGen This event is raised during query building for each condition in the query and it allows you to replace the SQL expression generated for this condition.

Methods

Type Name Description
void CheckModelObject(DataModel model) Checks if model object has appropriate type and raise exception if not
void CoreClear() Clears all query content. Can be overriden in derived classes.
Column CreateColumnCore() Creates the column object. This particular implementation returns and instance of DbColumn class
QueryFormats CreateFormats() Gets the formats of generated query language (SQL or other).
EntityAttrExpr CreateParentEntityAttrExpr(EntityAttr attr) Creates the parent entity attribute expression.
EqExpression CreateQueryExpr() Creates a sub-query expression.
Query CreateSubQuery() Creates the subquery.
Entity GetParentQueryRootEntity() Gets the entities from parent query.
List<Entity> GetUsedEntities() Gets the list of used entities.
TableList GetUsedTables() Gets the used tables.
void LoadNode(XmlReader reader, QueryReadWriteOptions rwOptions) Loads the root node.
DataModel NewModel() Creates a new model (an object of DataModel class or its descendant).
Boolean OnCondSqlGen(CondSqlGenEventArgs e) Raises the CondSqlGen event.
void ReadOnePropFromJson(JsonReader reader, String propName, QueryReadWriteOptions rwOptions) Reads the property from JSON reader or skip unused.
Task ReadOnePropFromJsonAsync(JsonReader reader, String propName, QueryReadWriteOptions rwOptions) Reads the property from JSON reader or skip unused (asynchronous way).
void SaveNodes(XmlWriter writer, QueryReadWriteOptions rwOptions) Saves the root nodes.
void WritePropertiesToJson(JsonWriter writer, QueryReadWriteOptions rwOptions) Saves content of the query to JSON.
Task WritePropertiesToJsonAsync(JsonWriter writer, QueryReadWriteOptions rwOptions) Saves content of the query to JSON (asynchronous way).