Skip to content

SqlQueryBuilder class

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

public class Korzh.EasyQuery.Db.SqlQueryBuilder
: DbQueryBuilder, IQueryBuilder
TypeNameDescription
BooleanCanBuildGets a value indicating whether the query can be built.
SqlStatementResultGets the result object
TypeNameDescription
CondSqlGenEventHandlerCondSqlGenThis 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.
TypeNameDescription
BooleanBuildParamSQL()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.
BooleanBuildSQL()Builds the SQL statement.
BooleanBuildSQLEx(String extraColumns, String extraConditions)Builds the SQL with some additional columns and conditions which can be passed in parameters
QueryBuilderResultCreateResult()Creates the result object
StringGetParamExpr(String id)Gets the parameter expression.
voidOnCondSqlGen(CondSqlGenEventArgs e)Raises the CondSqlGen event.
StringProcessScalarValue(Condition cnd, String value, DataType dataType, ScalarExprOptions exprOptions)Processes scalar value and returns SQL (or some other query language) expression.
voidResetSqlBuilder()Resets the SQL builder.