Skip to content

QueryFormats class

Represents different formats of statements.

public class Korzh.EasyQuery.QueryFormats
: IQueryFormats
TypeNameDescription
DataTypeListquotedTypesRepresents list of data types that must be quoted in result SQL.
TypeNameDescription
BooleanAlphaAliasGets or sets a value indicating whether column alias should have only “alpha” symbols.
StringDateFormatGets or sets the format of date constant values in generated SQL statements.
StringDateTimeFormatGets or sets the format of date/time constant values in generated SQL statements.
EOLSymbolEOLGets or sets the end-of-line symbol(s)
StringEscapeSymbolGets or sets the escape symbol.
StringFalseValueGets or sets the text used for “False” value in SQL expressions.
BooleanFilterModeGets or sets a value indicating whether we should generate the query for filter (e.g. without table names in field representations).
StringLowerFuncNameGets or sets the name of the LOWER function.
Int32MaxIdentLenGets or sets a maximum length of identifiers (e.g. table or column aliases) in generated queries. 0 - means that this options is ignored
StringMoneySuffixGets or sets the suffix for the values with “money” or “currency” types.
OrderByStylesOrderByStyleGets or sets the style of ORDER BY clause.
BooleanQuoteBoolGets or sets a value indicating whether currently used SQL syntax requires to quote the boolean values.
BooleanQuoteColumnAliasGets or sets a value indicating whether all columns aliases must be quotes in result SQL.
BooleanQuoteTimeGets or sets a value indicating whether currently used SQL syntax requires to quote the date and time values.
BooleanSupportPagingGets or sets a value indicating whether paging commands (like OFFSET/FETCH) are supported.
StringTimeFormatGets or sets the format of time constant values used in generated SQL statements.
StringTrueValueGets or sets the text used for “True” value in SQL expressions.
ColumnAliasesUsageUseColumnAliasesGets or sets the value that determine when column aliases must be used in result SQL.
BooleanUseTimezoneOffsetGets or sets a value indicating whether query builder should use the timezone offset when generates date/time values. The timezone offeset is usually received from the client side.
BooleanUseUtcTimeGets or sets a value indicating whether query builder should use UTC time when it works with date/time values.
CharWildcardAnyGets or sets the wild symbol used in LIKE SQL operator (% by default).
CharWildcardSingleGets or sets the wildcard symbol used in LIKE SQL operator to match any single charcter (_ by default).
TypeNameDescription
voidCopyFrom(IQueryFormats source)Copies the formats from another formats object.
voidCopyFromCore(QueryFormats source)Copies all formats from some QueryFormats object.
BooleanEquals(Object obj)Determines whether the specified System.Object is equal to this instance.
StringGetEolSymbol()Gets the string representation of end-of-line symbol(s)
Int32GetHashCode()Returns a hash code for this instance.
BooleanIsQuotedType(DataType type)Determines whether the specified type must be quoted.
voidLoadFromXmlReader(XmlReader reader)Loads formats from XML reader.
voidLoadNode(String nodeName, String nodeValue)Loads the root node of the Korzh.EasyQuery.QueryFormats object.
voidReadFromJson(JsonReader reader)Loads QueryFormats from JSON. Calls Korzh.EasyQuery.QueryFormats.ReadOnePropFromJson(Newtonsoft.Json.JsonReader,System.String) function.
TaskReadFromJsonAsync(JsonReader reader)Loads QueryFormats from JSON (asynchronous way). Calls Korzh.EasyQuery.QueryFormats.ReadOnePropFromJsonAsync(Newtonsoft.Json.JsonReader,System.String) function.
voidReadOnePropFromJson(JsonReader reader, String propName)Loads a property of QueryFormats.
TaskReadOnePropFromJsonAsync(JsonReader reader, String propName)Loads a property of QueryFormats (asynchronous way).
voidSaveNodes(XmlWriter writer)Saves the root nodes of the formats.
voidSaveToXmlWriter(XmlWriter writer, String rootNodeName)Saves formats to XML writer.
voidWriteContentToJson(JsonWriter writer)Saves the properties of QueryFormats to JSON.
TaskWriteContentToJsonAsync(JsonWriter writer)Saves the properties of QueryFormats to JSON (asynchronous way).
voidWriteToJson(JsonWriter writer)Saves QueryFormats to JSON. Calls Korzh.EasyQuery.QueryFormats.WriteContentToJson(Newtonsoft.Json.JsonWriter) function.
TaskWriteToJsonAsync(JsonWriter writer)Saves QueryFormats to JSON (asynchronous way). Calls Korzh.EasyQuery.QueryFormats.WriteContentToJsonAsync(Newtonsoft.Json.JsonWriter) function.