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