SqlQueryBuilder class

Lets you build SQL commands based on Korzh.EasyQuery.Db.DbQuery object

public class Korzh.EasyQuery.Db.SqlQueryBuilder
    : DbQueryBuilder, IQueryBuilder

Properties

Type	Name	Description
Boolean	CanBuild	Gets a value indicating whether the query can be built.
SqlStatement	Result	Gets the result object

Events

Type	Name	Description
CondSqlGenEventHandler	CondSqlGen	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

Type	Name	Description
Boolean	BuildParamSQL()	The same as Korzh.EasyQuery.Db.SqlQueryBuilder.BuildSQL method but generates parametrized SQL expression where all values are replaced by parameters (e.g. @param1). You can access full list of parameters used in generated SQL statement through Query.Params property.
Boolean	BuildSQL()	Builds the SQL statement.
Boolean	BuildSQLEx(String extraColumns, String extraConditions)	Builds the SQL with some additional columns and conditions which can be passed in parameters
QueryBuilderResult	CreateResult()	Creates the result object
String	GetParamExpr(String id)	Gets the parameter expression.
void	OnCondSqlGen(CondSqlGenEventArgs e)	Raises the CondSqlGen event.
String	ProcessScalarValue(Condition cnd, String value, DataType dataType, ScalarExprOptions exprOptions)	Processes scalar value and returns SQL (or some other query language) expression.
void	ResetSqlBuilder()	Resets the SQL builder.