DbQueryFormats PropertiesEasyQuery WinForms API Reference
The DbQueryFormats type exposes the following members.
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