SqlQueryBuilder MembersEasyQuery ASP.NET API Reference

The SqlQueryBuilder type exposes the following members.

Public methodSqlQueryBuilder
Initializes a new instance of the SqlQueryBuilder class.
Back to Top

Public methodBuildParamSQL
The same as 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 Params property.
Public methodBuildSQL
Builds the SQL statement.
Public methodBuildSQLEx
Builds the SQL with some additional columns and conditions which can be passed in parameters
Protected methodCalcScalarExpr
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 ProcessScalarValue(String, DataType, ScalarExprOptions) method to get the result.
(Inherited from BaseQueryBuilder.)
Public methodOnlineEquals
Determines whether the specified OnlineObject is equal to the current OnlineObject.
(Inherited from OnlineObject.)
Protected methodOnlineFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from OnlineObject.)
Public methodOnlineGetHashCode
Serves as a hash function for a particular type.
(Inherited from OnlineObject.)
Public methodOnlineGetType
Gets the OnlineType of the current instance.
(Inherited from OnlineObject.)
Protected methodOnlineMemberwiseClone
Creates a shallow copy of the current OnlineObject.
(Inherited from OnlineObject.)
Protected methodOnCondSqlGen
Raises the [E:CondSqlGen] event.
Protected methodProcessDefaultMacros
Processes the default macros such as ${Today}, ${True} and others.
(Inherited from BaseQueryBuilder.)
Protected methodProcessMacros
Processes the macro values (both user-defined and default)
(Inherited from BaseQueryBuilder.)
Protected methodProcessScalarValue
Processes the scalar value and returns SQL (or other query language) expression.
(Inherited from BaseQueryBuilder.)
Protected methodResetSqlBuilder
Resets the SQL builder.
Public methodToString
Returns a OnlineString that represents this instance.
(Inherited from BaseQueryBuilder.)
Back to Top

Protected fieldcondFieldName
The name of the field in currently processing condition (used for generation of parameter names)
(Inherited from BaseQueryBuilder.)
Protected fieldparamMode
This property indicated whethere generated SQL should include parameters instead of real values.
(Inherited from BaseQueryBuilder.)
Back to Top

Public propertyCanBuild
Gets a value indicating whether this instance can be built.
Public propertyFormats
Gets the DbQueryFormats object in the parent query.
Public propertyModel
Gets the model. An instance of DataModel class or one of its descendants (for example DbModel)
(Inherited from BaseQueryBuilder.)
Public propertyOptions
Gets the DbQueryOptions object used in the parent query.
Protected propertyQuery
Gets the query object associated with the builder.
Public propertyResult
Gets the result.
Public propertyResultObject
Gets the result object. It could be some SQL statement or and an IQueryable object created by LINQ query builder.
(Overrides BaseQueryBuilder ResultObject.)
Public propertyResultType
Gets the the result type.
(Inherited from BaseQueryBuilder.)
Back to Top

Public eventCondSqlGen
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.
Back to Top
See Also