Lets you build SQL commands based on Korzh.EasyQuery.Db.DbQuery object
public abstract class Korzh.EasyQuery.Db.DbQueryBuilder
: IQueryBuilder
Package: Korzh.EasyQuery.Db (targets: netstandard2.0)
Assembly: Korzh.EasyQuery.Db.dll
Constructors
Fields
| Name |
Type |
Description |
| _isParamMode |
bool |
This property indicated whethere generated SQL should include parameters instead of real values. |
| condFieldName |
string |
The name of the field in currently processing condition (used for generation of parameter names) |
Properties
| Name |
Type |
Description |
| EscapeDef |
string |
contains escape symbol definition which will be added to the condition if necessary |
| Extras |
SqlExtras |
Gets the Korzh.EasyQuery.Db.SqlExtras object which defines some extra clauses and options of the generated query. |
| Formats |
SqlFormats |
Gets the formats of the result query statement. This is a structure which allows you to set different formatting option of generated SQL (or other query language) statements. For more information please read Korzh.EasyQuery.Db.SqlFormats reference. |
| Model |
DbModel |
Gets the model. An instance of Korzh.EasyQuery.DataModel class or one of its descendants (for example DbModel) |
| Options |
QueryBuilderOptions |
Gets or sets the builder's options. |
| Query |
DbQuery |
Gets the query object associated with the builder. |
| QueryParams |
QueryParamList |
Gets the list of query parameters (for parameterized queries) |
| Result |
QueryStatement |
QueryBuilder result. |
| StatementType |
Type |
Gets the the statement type. |
Events
| Name |
Type |
Description |
| ConditionSqlGenerated |
ConditionSqlGeneratedEventHandler |
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
| Name |
Type |
Description |
| Build() |
bool |
Builds the query and stores the result in the Korzh.EasyQuery.Db.DbQueryBuilder.Result property. The result could be some SQL statement or and an IQueryable object created by LINQ query builder. |
CalcScalarExpr(Condition cnd, string value, DataType dataType, ScalarExprOptions exprOptions) |
string |
Calculates the scalar value and returns SQL (or other query language) expression. This function replaces all macros with their real values first and then call Korzh.EasyQuery.Db.DbQueryBuilder.ProcessScalarValue(Korzh.EasyQuery.Condition,System.String,EasyData.DataType,Korzh.EasyQuery.ScalarExprOptions) method to get the result. |
| GetGroupByExpr(QueryColumn column, SqlFormats formats) |
string |
Gets the column's expression using in GROUP BY clause. |
| GetOrderByExpr(QueryColumn column, SqlFormats formats) |
string |
Gets the columns expression for ORDER BY clause. |
GetParamExpr(string id) |
string |
Gets the parameter expression. |
| GetSelectExpr(QueryColumn column, SqlFormats formats) |
string |
Gets the columns expression for SELECT clause. |
ProcessDefaultMacros(StringBuilder sb, bool quoting = False) |
void |
Processes the default macros such as ${{Today}}, ${{True}} and others. |
ProcessMacros(Condition cnd, StringBuilder sb, DataType dataType, ScalarExprOptions exprOptions) |
void |
Processes the macro values (both user-defined and default) |
ProcessScalarValue(Condition cnd, string value, DataType dataType, ScalarExprOptions exprOptions) |
string |
Processes the scalar value and returns SQL (or other query language) expression. |
| ResetParamsIfNeeded() |
void |
Reset the list of parameters if its necessary |
| SetExtraParams(QueryParamList extraParams) |
void |
Sets the list of extra parameters (mainly for sub-queries) |
