QueryFormats class

Represents different formats of statements.

public class Korzh.EasyQuery.QueryFormats

Fields

Type Name Description
DataTypeList quotedTypes Represents list of data types that must be quoted in result SQL.

Properties

Type Name Description
Boolean AlphaAlias Gets or sets a value indicating whether column alias should have only "alpha" symbols.
String DateFormat Gets or sets the format of date constant values in generated SQL statements.
String DateTimeFormat Gets or sets the format of date/time constant values in generated SQL statements.
EOLSymbol EOL Gets or sets the end-of-line symbol(s)
String EscapeSymbol Gets or sets the escape symbol.
String FalseValue Gets or sets the text used for "False" value in SQL expressions.
Boolean FilterMode Gets or sets a value indicating whether we should generate the query for filter (e.g. without table names in field representations).
String LowerFuncName Gets or sets the name of the LOWER function.
Int32 MaxIdentLen Gets or sets a maximum length of identifiers (e.g. table or column aliases) in generated queries. 0 - means that this options is ignored
String MoneySuffix Gets or sets the suffix for the values with "money" or "currency" types.
OrderByStyles OrderByStyle Gets or sets the style of ORDER BY clause.
Boolean QuoteBool Gets or sets a value indicating whether currently used SQL syntax requires to quote the boolean values.
Boolean QuoteColumnAlias Gets or sets a value indicating whether all columns aliases must be quotes in result SQL.
Boolean QuoteTime Gets or sets a value indicating whether currently used SQL syntax requires to quote the date and time values.
Boolean SupportPaging Gets or sets a value indicating whether paging commands (like OFFSET/FETCH) are supported.
String TimeFormat Gets or sets the format of time constant values used in generated SQL statements.
String TrueValue Gets or sets the text used for "True" value in SQL expressions.
ColumnAliasesUsage UseColumnAliases Gets or sets the value that determine when column aliases must be used in result SQL.
Boolean UseTimezoneOffset Gets 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.
Boolean UseUtcTime Gets or sets a value indicating whether query builder should use UTC time when it works with date/time values.
Char WildcardAny Gets or sets the wild symbol used in LIKE SQL operator (% by default).
Char WildcardSingle Gets or sets the wildcard symbol used in LIKE SQL operator to match any single charcter (_ by default).

Methods

Type Name Description
void CopyFrom(QueryFormats source) Copies all formats from some QueryFormats object.
Boolean Equals(Object obj) Determines whether the specified System.Object is equal to this instance.
String GetEolSymbol() Gets the string representation of end-of-line symbol(s)
Int32 GetHashCode() Returns a hash code for this instance.
Boolean IsQuotedType(DataType type) Determines whether the specified type must be quoted.
void LoadFromJsonDict(JsonDict dict) Loads QueryFormats from the IDictionary<string, object> object. Used for deserialization from JSON
void LoadFromXmlReader(XmlReader reader) Loads formats from XML reader.
void LoadNode(String nodeName, String nodeValue) Loads the root node of the Korzh.EasyQuery.QueryFormats object.
void SaveNodes(XmlWriter writer) Saves the root nodes of the formats.
void SaveToJsonDict(JsonDict dict) Saves QueryFormats to IDictionary<string, object> object. Used for serialization to JSON
void SaveToXmlWriter(XmlWriter writer, String rootNodeName) Saves formats to XML writer.