DbSelectSqlGenerator Members
The DbSelectSqlGenerator type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
|
ConvertValueToSqlText |
Converts the value to SQL text.
|
|
|
FormatOrderByTableFieldSql |
Formats the order by fragment. Used by derived classes to add case sensitivity and other SQL text to the order by Table.Field parameter.
|
|
|
FormatSqlObject |
Formats the SQL object.
|
|
FormatStringValueForSql |
Formats the string value for SQL. Override if this method is not compatible with your database platform.
|
|
|
FormatValueForSqlWhereItem |
Formats a value for a SQL WHERE clause. Override if this method is not compatible with your database platform.
|
|
|
GenerateConditionSqlText |
Generates WHERE clause condition SQL text for the inputted WhereItem object.
Override if this method is not compatible with your database platform.
|
|
|
GenerateCountQueryStatement |
Generates a SQL statement to count the number of records from the database.
|
|
|
GenerateDeleteStatement |
Generates the delete statement.
|
|
|
GenerateEnumeratorSqlFieldText |
Generates SQL field text for an enumerator field. Override if this method is not compatible with your database platform.
|
|
|
GenerateFromClause |
Generates the FROM clause. Override if this method is not compatible with your database platform.
|
|
|
GenerateGroupBy |
Generates the group by.
|
|
|
GenerateInsertSqlStatement |
Generates the insert SQL statement.
|
|
|
GenerateJoins |
Generates the JOIN clauses. Override if this method is not compatible with your database platform.
|
|
|
GenerateNestedQuery |
Generates the nested query. Override if this method is not compatible with your database platform.
|
|
|
GenerateOrderByClause |
Generates the order by clause.
|
|
|
GenerateSelectClause |
Generates the SELECT clause. Override if this method is not compatible with your database platform.
|
|
|
GenerateSelectQueryStatement |
Generates the SELECT SQL statement.
|
|
|
GenerateSelectStatement |
Generates the SELECT SQL statement.
|
|
|
GenerateSetNullStatement |
Generates the set null statement.
|
|
|
GenerateTopRecordCountSqlText |
Generates the top record count SQL text. Override if this method is not compatible with your database platform.
|
|
|
GenerateUpdateSql |
Generates the update SQL.
|
|
|
GenerateWhereClause |
Generates the where clause. Override if this method is not compatible with your database platform.
|
|
|
GenerateWhereEnumItemSqlText |
Generates the where item enumerator SQL text.
|
|
|
GenerateWhereItemSqlFieldNameText |
Generates the where item SQL field name text for the inputted WhereItem object.
Override if this method is not compatible with your database platform.
|
|
|
GenerateWhereItemSqlText |
Generates WHERE SQL fragment text for the inputted WhereItem object.
Override if this method is not compatible with your database platform.
|
Properties
| Name | Description | |
|---|---|---|
|
SqlLinePrefix |
Gets the SQL prefix that needs to be at the beginning of each line in the generated SQL statement. Useful in
formatting nested SQL statements. This usually contains TAB characters.
|
|
|
SqlObjectPrefixChar |
Gets the SQL object prefix character.
|
|
|
SqlObjectSuffixChar |
Gets the SQL object suffix character.
|