Base class for all query builder classes like .
public abstract class Korzh .EasyQuery.BaseQueryBuilder
Type Name Description String
condFieldName The name of the field in currently processing condition (used for generation of parameter names) Boolean
paramMode This property indicated whethere generated SQL should include parameters instead of real values.
Type Name Description QueryFormats
Formats Gets the formats of generated 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.QueryFormats reference. DataModel
Model Gets the model. An instance of Korzh.EasyQuery.DataModel class or one of its descendants (for example DbModel) Query
Query Gets the query object associated with the builder. Type
ResultType Gets the the result type.
Type Name Description String
CalcScalarExpr(Condition
cnd, String
value, DataType
dataType, ScalarExprOptions
exprOptions) 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.BaseQueryBuilder.ProcessScalarValue(Korzh.EasyQuery.Condition,System.String,Korzh.EasyQuery.DataType,Korzh.EasyQuery.ScalarExprOptions) method to get the result. QueryFormats
CreateQueryFormats() Creates Korzh.EasyQuery.QueryFormats object compatible with this type of query builder. Should be overriden in descendant classes QueryBuilderResult
CreateResult() Creates the result object. String
GetParamExpr(String
id) Gets the parameter expression. QueryBuilderResult
GetResult() void
ProcessDefaultMacros(StringBuilder
sb, Boolean
quoting = False) Processes the default macros such as ${Today}, ${True} and others. void
ProcessMacros(Condition
cnd, StringBuilder
sb, DataType
dataType, Boolean
quoting = False) Processes the macro values (both user-defined and default) String
ProcessScalarValue(Condition
cnd, String
value, DataType
dataType, ScalarExprOptions
exprOptions) Processes the scalar value and returns SQL (or other query language) expression. String
ToString() Returns a System.String
that represents this instance.