DbQuery class

Represents query for building SQL command

public class Korzh.EasyQuery.Db.DbQuery
    : Query

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

Assembly: Korzh.EasyQuery.Db.dll

Constructors

Name	Type	Description
DbQuery(DataModel model, Query parentQuery)	void	Initializes a new instance of the Korzh.EasyQuery.Db.DbQuery class.
DbQuery(DataModel model)	void	Initializes a new instance of the Korzh.EasyQuery.Db.DbQuery class.

Properties

Name	Type	Description
ExtraTables	TableList	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
Options	SqlExtras	Gets the Korzh.EasyQuery.Db.SqlExtras object which defines some extra clauses of generated query.
ResultColumns	IEnumerable<QueryColumn>	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).

Methods

Name	Type	Description
CheckModelObject(DataModel model)	void	Checks if model object has appropriate type and raise exception if not
CoreClear()	void	Clears all query content. Can be overriden in derived classes.
CreateColumn(IColumnDescriptor& modreq(System.Runtime.InteropServices.InAttribute) desc)	QueryColumn	Creates a column by its descriptor
CreateParentEntityAttrExpr(EntityAttr attr)	EntityAttrExpr	Creates the parent entity attribute expression.
CreateQueryExpr()	EqExpression	Creates a sub-query expression.
CreateSubQuery()	Query	Creates the subquery.
GetParentQueryRootEntity()	Entity	Gets the entities from parent query.
GetUsedEntities()	List<Entity>	Gets the list of used entities.
GetUsedTables()	TableList	Gets the used tables.
LoadNode(XmlReader reader, BitOptions rwOptions)	void	Loads the root node.
NewModel()	DataModel	Creates a new model (an object of DataModel class or its descendant).
ReadOnePropFromJsonAsync(JsonReader reader, string propName, BitOptions rwOptions)	Task	Reads the property from JSON reader or skip unused (asynchronous way).
SaveNodes(XmlWriter writer, BitOptions rwOptions)	void	Saves the root nodes.
WritePropertiesToJsonAsync(JsonWriter writer, BitOptions rwOptions)	Task	Saves content of the query to JSON (asynchronous way).