BaseQueryBuilder class

Base class for all query builder classes.

public abstract class Korzh.EasyQuery.BaseQueryBuilder
    : IQueryBuilder

Fields

Type	Name	Description
`Boolean`	_isParamMode	This property indicated whethere generated SQL should include parameters instead of real values.
`String`	condFieldName	The name of the field in currently processing condition (used for generation of parameter names)

Properties

Type	Name	Description
`QueryFormats`	Formats	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.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.
`QueryParamList`	QueryParams	Gets the list of query parameters (for parameterized queries)
`Type`	ResultType	Gets the the result type.

Methods

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`	CreateFormats()	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()	Gets the result object. It could be some SQL statement or and an IQueryable object created by LINQ query builder.
`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, `ScalarExprOptions` exprOptions)	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.
`void`	ResetParamsIfNeeded()	Reset the list of parameters if its necessary
`void`	SetExtraParams(`QueryParamList` extraParams)	Sets the list of extra parameters (mainly for sub-queries)
`String`	ToString()	Returns a `System.String` that represents this instance.