SqlQueryBuilder class

April 28, 2021

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

public class Korzh.EasyQuery.Db.SqlQueryBuilder
    : DbQueryBuilder

Package: Korzh.EasyQuery.Db (targets: netstandard2.0)

Assembly: Korzh.EasyQuery.Db.dll

Constructors

Name Type Description
SqlQueryBuilder(DbQuery query) void Initializes a new instance of the Korzh.EasyQuery.Db.SqlQueryBuilder class.

Properties

Name Type Description
CanBuild bool Gets a value indicating whether the query can be built.
Portion ResultSetPortion
Result SqlStatement Gets the result.

Events

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

Name Type Description
Build() bool Builds the query and stores the result in the Korzh.EasyQuery.Db.SqlQueryBuilder.Result property.
BuildParamSQL() bool 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.
BuildSQL() bool Builds the SQL statement.
BuildSQLEx(string extraColumns, string extraConditions) bool Builds the SQL with some additional columns and conditions which can be passed in parameters
GetParamExpr(string id) string Gets the parameter expression.
OnCondSqlGen(ConditionSqlGeneratedEventArgs e) void Raises the CondSqlGen event.
ProcessScalarValue(Condition cnd, string value, DataType dataType, ScalarExprOptions exprOptions) string Processes scalar value and returns SQL (or some other query language) expression.
ResetSqlBuilder() void Resets the SQL builder.