BaseQueryBuilder class

Base class for all query builder classes like .

public abstract class Korzh.EasyQuery.BaseQueryBuilder
    : IQueryBuilder

Fields

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.

Properties

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.

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