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