The following tables list the members exposed by QueryTransformer.
Public Properties
| Name | Description | |
|---|---|---|
 | Aggregations | Gets the list of aggregation columns. |
| Columns | Returns the list of output columns of initial query. |
| Filters | Gets the list of filtration conditions. |
| IsResultQueryWrapped | Indicates if the query will be wrapped in a sub-query after transformation. |
| IsSupportLimitCount | Indicates if it's possible to limit the number of records by means of the current database server SQL syntax. |
| IsSupportLimitOffset | Indicates if it's possible to skip first records by means of the current database server SQL syntax. |
| IsUpdating | Indicates that the component is in update mode now. |
| QueryBuilder | Gets or sets the reference to the QueryBuilder component that contains the initial query. |
| ResultCount | Gets or sets the number of records to return. |
| ResultOffset | Gets or sets the number of first records to be skipped. |
| SelectMode | Gets or sets the selection mode of result SQL query (DISTINCT, ALL or default). |
| Sortings | Gets the list of sortings. |
| Sql | Gets the modidied SQL query text. |
| SqlBuilder | Gets or sets the reference to the SQLBuilder component that is used to generate the modified query. |
| XML | Gets or sets the content of Query Transformer as string in a form of XML document. |
Public Methods
| Name | Description | |
|---|---|---|
 | BeginUpdate | Prevents the component from SQL generation until the EndUpdate method is called. |
| EndUpdate | Resumes SQL generation after it was suspended by the BeginUpdate method. |
| ExportToXML | Overloaded. Saves the content of Query Transformer to XML file. |
| ImportFromXML | Overloaded. Loads the content of Query Transformer from file in a form of XML document. |
| OrderBy | Overloaded. Adds sorting to the query. |
| Select | Overloaded. Adds aggregate defined by the SelectedColumn object. |
| SelectRecordsCount | Overloaded. Adds the "COUNT(*)" aggregate to the query. |
| Skip | Sets the number of first records to be skipped. |
| Take | Sets the number of records to return. |
| Where | Overloaded. Adds filtration condition to the query. |
Public Events
| Name | Description | |
|---|---|---|
 | SqlUpdated | Occurs each time the component updates the output SQL query text. |
See Also