The SqlQuery type exposes the following members.
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | SqlQuery |
SqlQuery constructor.
|
Methods
| Name | Description | |
|---|---|---|
| AddSqlTokenToEnd |
Adds a new SqlToken to the end of the query.
|
| AddSqlTokenToStart |
Adds a new SqlToken to the start of the query.
|
| Append(SqlQuery) |
Append an entire sql query.
|
| Append(SqlToken) |
Shorter method for appending tokens.
|
| BuildSql |
Builds an SQL representation of the SqlQuery object with line breaks.
|
| BuildSql(Boolean) |
Builds an SQL representation of the SqlQuery object with optional line breaks.
|
| BuildSqlNoLineBreaks |
Renders the current SqlQuery object to a string that contains a valid
SQL query. Enumerates the sqlTokens object and calls BuildSql on each
SqlToken node then returns the concatenated results.
|
| Clone |
Clone the current SqlQuery object.
|
 | CreateFromSerial |
Creates a new SqlQuery object from a serialized string.
|
| FindFirstSqlTokenByClause |
Find first token in a clause.
|
| FindLastSqlTokenByClause |
Find last token in a clause.
|
| FindSqlTokensByClause |
Find tokens by clause.
|
| FindSqlTokensByColumnName |
Find tokens by column name.
|
| FindSqlTokensByGroup |
Find tokens by group.
|
| FindSqlTokensByName |
Find tokens by name.
|
| FindSqlTokensByTableName |
Find tokens by table name.
|
| FindSqlTokensByType |
Find tokens by type.
|
| FromSerial |
Set an SqlQuery object from a serialized string.
|
| GetAllTokens |
Returns an array with all the SqlTokens in this query.
|
| GetAllTokensCloned |
Returns a cloned copy of all SqlTokens in this query.
|
| GetFirstToken |
Returns the frist token in the query.
|
| GetLastToken |
Returns the last token in the query.
|
| GetSerial |
Return the last serailized object state if there is one.
|
| GetSerialLength |
Returns the length of the generated serial string.
|
| GetSql |
Returns the last built SQL query.
|
| GetSqlLength |
Returns the length of the generated sql string.
|
| GetSqlTokenCount |
Returns the count of tokens in the query.
|
 | GetTabStr |
Returns a string with len \t characters in it.
|
| GetTokenAt |
Returns the token at the given index.
|
| InsertBeforeLast |
Inserts a token before the last token in the token list.
|
| InsertSqlQueryAfter |
Inserts the given SqlQuery object after the target node.
|
| InsertSqlTokenAfter |
Adds a new SqlToken in after an existing LinkedListNode.
|
| InsertSqlTokenBefore |
Adds a new SqlToken in before an existing LinkedListNode.
|
| NormalizeIndexes |
Normalize the index values of the query.
|
| RemoveFirstToken |
Remove the first token from the sql query.
|
| RemoveLastToken |
Remove the last token from the query.
|
| RemoveToken |
Remove the target token from the sql query.
|
| RemoveTokenAt |
Removes a token at the given index.
|
| SetBracketsAll |
Sets the backet visibility settings for all SqlToken objects in the query.
|
| SetClauseAll |
Updates the SqlClause value for the entire query.
|
| SetEscapeCharsAll |
Updates the escape character on all SqlTokens
|
| SetGroupCharsAll |
Updates the grouping character on all SqlTokens.
|
| SetGroupIndexAll |
Sets the group index for all SqlTokens.
|
| ToDetailedString |
Returns a string representation of this object's contents.
|
| ToSerial |
Convert an SqlQuery object to a serialized string.
|
Fields
| Name | Description | |
|---|---|---|
 | serial |
Stores the last serialized version of this object.
|
 | SERIALIZATION_ROW_DELIM |
Holds the row serialization string for serializing the SqlToken collection.
|
| sql |
Stores the last built SQL query.
|
| sqlTokens |
The main collection of SqlTokens
|
| tokenDoesntExistErrMsg |
Private string used in exception messages.
|
| tokenExistsErrMsg |
Private string used in exception messages.
|
See Also