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.