Skip to content

SqlExtras class

Represents different extra clauses of SELECT query.

public class Korzh.EasyQuery.Db.SqlExtras
TypeNameDescription
BooleanIsParamModeGets or sets a value indicating whether we should replace all values in conditions with parameters during SQL generation.
BooleanLazyJoinsGets or sets a value indicating whether “lazy outer joins” scheme is used. If it is trueKorzh.EasyQuery.Db.SqlQueryBuilder will “delay” outer joins and apply them only when all inner joins have been made. Such behaviour will allow to get more records in result set.
StringLimitClauseGets or sets the content of LIMIT clause in result SQL statement
QueryParamListParameters
BooleanSelectDistinctGets or sets a value indicating whether SELECT clause must contain DISTINCT option.
StringSelectTopGets or sets the content of TOP command in SELECT clause.
TypeNameDescription
voidCopyFrom(SqlExtras ecc)
voidLoadOptionsFromXmlReader(XmlReader reader)
voidReadFromJson(JsonReader reader)Read the SQL extras from JSON.
TaskReadFromJsonAsync(JsonReader reader)Read the SQL extras from JSON (asynchronous way).
voidSaveToXmlWriter(XmlWriter writer, String nodeName)
voidSetClauseByName(String propName, Object propValue)Sets one property according to its name and value.
voidWriteToJson(JsonWriter writer)Writes the content of SqlExtras object to JSON.
TaskWriteToJsonAsync(JsonWriter writer)Writes the content of SqlExtras object to JSON (asynchronous way).