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