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