DbQueryFormats MembersEasyQuery WinForms API Reference

The DbQueryFormats type exposes the following members.
Constructors

  NameDescription
Public methodDbQueryFormats
Initializes a new instance of the DbQueryFormats class.
Back to Top
Methods

  NameDescription
Public methodCopyFrom
Copies all formats from some DbQueryFormats object.
(Overrides QueryFormats CopyFrom(QueryFormats).)
Public methodEquals
Determines whether the specified OnlineObject is equal to this instance.
(Overrides QueryFormats Equals(Object).)
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 methodGetEolSymbol
Gets the string representation of end-of-line symbol(s)
(Inherited from QueryFormats.)
Public methodGetHashCode
Returns a hash code for this instance.
(Overrides QueryFormats GetHashCode .)
Public methodOnlineGetType
Gets the OnlineType of the current instance.
(Inherited from OnlineObject.)
Public methodIsQuotedType
Determines whether the specified type must be quoted.
(Inherited from QueryFormats.)
Public methodLoadFromDictionary
Loads DbQueryFormats from the IDictionary<string, object> object. Used for deserialization from JSON
(Overrides QueryFormats LoadFromDictionary(IDictionary String, Object ).)
Public methodLoadFromXmlReader
Loads formats from XML reader.
(Inherited from QueryFormats.)
Protected methodLoadNode
Loads the root node of the DbQueryFormats object.
(Overrides QueryFormats LoadNode(String, String).)
Protected methodOnlineMemberwiseClone
Creates a shallow copy of the current OnlineObject.
(Inherited from OnlineObject.)
Protected methodSaveNodes
Saves DbQueryFormats object to XML writer.
(Overrides QueryFormats SaveNodes(XmlWriter).)
Public methodSaveToDictionary
Saves DbQueryFormats to IDictionary<string, object> object. Used for serialization to JSON
(Overrides QueryFormats SaveToDictionary(IDictionary String, Object ).)
Public methodSaveToXmlWriter
Saves formats to XML writer.
(Inherited from QueryFormats.)
Public methodSetDefaultFormats
Sets the default formats for different types of databases.
Public methodOnlineToString
Returns a string that represents the current object.
(Inherited from OnlineObject.)
Back to Top
Fields

  NameDescription
Protected fieldquotedTypes
Represents list of data types that must be quoted in result SQL.
(Inherited from QueryFormats.)
Protected fieldSubQueryLevel
Indicates the level of sub-query for the query we are generating currently. Default value is 0 which means we generate the main query.
Back to Top
Properties

  NameDescription
Public propertyAlphaAlias
Gets or sets a value indicating whether column alias should have only "alpha" symbols.
(Inherited from QueryFormats.)
Public propertyBracketJoins
Gets or sets a value indicating whether Korzh.EasyQuery must bracket joins in result SQL statement.
Public propertyDateFormat
Gets or sets the format of date constant values in generated SQL statements.
(Inherited from QueryFormats.)
Public propertyDateTimeFormat
Gets or sets the format of date/time constant values in generated SQL statements.
(Inherited from QueryFormats.)
Public propertyStatic memberDefault
Gets the default set of formats.
Public propertyDefaultSchemaName
Gets or sets the name of the default schema.
Public propertyEOL
Gets or sets the end-of-line symbol(s)
(Inherited from QueryFormats.)
Public propertyEscapeSymbol
Gets or sets the escape symbol.
(Inherited from QueryFormats.)
Public propertyFalseValue
Gets or sets the text used for "False" value in SQL expressions.
(Inherited from QueryFormats.)
Public propertyFilterMode
Gets or sets a value indicating whether we should generate the query for filter (e.g. without table names in field representations).
(Inherited from QueryFormats.)
Public propertyFormatType
Gets or sets the format type.
Public propertyGroupByCalcColumns
Gets or sets a value indicating whether SQL generator should use calculated columns "as is" in GROUP BY clause
Public propertyIdentQuote1
Gets or sets the left quote symbol for identifiers (double-quote by default).
Public propertyIdentQuote2
Gets or sets the right quote symbol for identifiers (double-quote by default).
Public propertyLowerFuncName
Gets or sets the name of the LOWER function.
(Inherited from QueryFormats.)
Public propertyMaxIdentLen
Gets or sets a maximum length of identifiers (e.g. table or column aliases) in generated queries. 0 - means that this options is ignored
(Inherited from QueryFormats.)
Public propertyMoneySuffix
Gets or sets the suffix for the values with "money" or "currency" types.
(Inherited from QueryFormats.)
Public propertyOrderByStyle
Gets or sets the style of ORDER BY clause.
(Inherited from QueryFormats.)
Public propertyQuoteBool
Gets or sets a value indicating whether currently used SQL syntax requires to quote the boolean values.
(Inherited from QueryFormats.)
Public propertyQuoteColumnAlias
Gets or sets a value indicating whether all columns aliases must be quotes in result SQL.
(Inherited from QueryFormats.)
Public propertyQuoteTime
Gets or sets a value indicating whether currently used SQL syntax requires to quote the date and time values.
(Inherited from QueryFormats.)
Public propertySqlQuote1
Gets or sets the left quote symbol (double-quote by default).
Public propertySqlQuote2
Gets or sets the right quote symbol (double-quote by default).
Public propertySqlSyntax
Gets or sets the type of SQL syntax.
Public propertySupportPaging
Gets or sets a value indicating whether paging commands (like OFFSET/FETCH) are supported.
Public propertyTimeFormat
Gets or sets the format of time constant values used in generated SQL statements.
(Inherited from QueryFormats.)
Public propertyTrueValue
Gets or sets the text used for "True" value in SQL expressions.
(Inherited from QueryFormats.)
Public propertyUseAsInFrom
Gets or sets a value indicating whether we must add AS conjuction between table name and alias in the FROM clause.
Public propertyUseColumnAliases
Gets or sets the value that determine when column aliases must be used in result SQL.
(Inherited from QueryFormats.)
Public propertyUseDbName
Gets or sets a value indicating whether Korzh.EasyQuery will add database name into table names in result SQL statememnt.
Public propertyUseEntityContainerName
Gets or sets a value indicating whether SQL generator should use entity container name for table definitions in FROM clause
Public propertyUseSchema
Gets or sets a value indicating whether Korzh.EasyQuery will use schema in result SQL statememnt.
Public propertyUseTableAlias
Gets or sets a value indicating whether we will use table aliases in generated queries.
Public propertyWildSymbol
Gets or sets the wild symbol used in LIKE SQL operator (% by default).
(Inherited from QueryFormats.)
Back to Top
See Also