| SqlHelper Methods |
The SqlHelper type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | AddColumnAlias |
Adds the column alias to the given expression
|
| AddColumns |
Adds the columns.
|
| AddOrderBy |
Adds the order by to an existing one.
|
| AddWhereCondition(String, String) |
Adds where condition to the expression using AND operator.
|
| AddWhereCondition(String, String, String) |
Adds where condition to the expression.
|
| AppendQuery |
Combines the given queries with the operator
|
| ApplyOver |
Applies the over clause to the given expression
|
 | BuildIntList |
Builds the list of integers separated by colon. Does not remove duplicities. Output of this method can be consumed by
SQL table-valued function [Func_Selection_ParseIDs] which parses string and returns table.
|
| BuildIntTable |
Gets a table-valued parameter for database calls. Is intended for usage with CMS_Type_Integers database type.
|
| CombineQueries |
Combines the given queries with the operators
|
| EnsureFullName |
Ensures full name of the given column
|
| EnsureMissingColumns(ICollectionListString) | Obsolete.
Ensures the missing columns in the given lists of columns
|
| EnsureMissingColumns(IListString) | Obsolete.
Ensures the missing columns in the given lists of columns
|
| EnsureMissingColumns(ICollectionQueryColumnList) |
Ensures the missing columns in the given collection of QueryColumnList instances
|
| EnsureOrderByColumns | Obsolete.
Ensures that the order by columns are provided within the list of columns as aliases, modifies the order by expression to the aliases of those columns
|
| EscapeLikeQueryPatterns |
Escapes characters for query which use LIKE pattern.
|
| EscapeLikeText |
Escapes characters for query which use LIKE pattern (%, _, [, ] and ^).
|
| EscapeQuotes |
Escapes single quotes in string value used for SQL query (value's => value''s).
|
| ExceptQueries |
Returns the query created as an EXCEPT of the given queries.
|
| GetAggregation |
Gets the aggregation expression from the given expression
|
| GetBetween |
Gets the condition matching values of the column between from and to
|
| GetCase |
Returns statement for the CASE expressions.
|
| GetCaseColumn |
Returns statement for column with case expressions.
This statement is used for evaluating a set of boolean expressions to determine the result. First case has highest priority.
|
| GetCaseOrderBy(IEnumerableString) |
Returns order by statement based on case boolean expressions. First case has highest priority.
|
| GetCaseOrderBy(String) |
Returns order by statement based on case boolean expressions. First case has highest priority.
|
| GetCast |
Get the CAST expression.
|
| GetColumnName |
Gets the column name from the given SQL column expression
|
| GetComment |
Gets a multiline SQL comment for simple input text (must not contain any open comment sequence)
|
| GetConvert |
Gets the convert expression.
|
| GetDBSchema |
Returns DB object scheme from settings.
|
| GetDBSchemaOrDefault |
Returns DB object scheme from settings or default value.
|
| GetIsNumeric |
Gets the ISNUMERIC expression.
|
| GetJoin |
Gets the join expression
|
| GetJoinType |
Gets the join expression
|
| GetNestedQuery |
Gets a nested query using nested SELECT for further evaluation
|
| GetOrderByColumnName(String) |
Gets the column name from the given SQL column expression
|
| GetOrderByColumnName(String, String) |
Gets the column name from the given SQL column expression
|
| GetParamCacheString |
Gets the parameters string.
|
| GetParameterName |
Gets the parameter name
|
| GetParamString |
Gets the parameters string.
|
| GetResultsString |
Gets the results as a string for log.
|
| GetRound |
Gets the round expression
|
| GetRowNumber |
Gets the row number expression
|
| GetSafeOwner |
Returns safe string representing DB owner.
|
| GetSafeQueryString(String) |
Returns safe sql query string - escapes apostrophes and escapes wildcard characters _, %, [].
|
| GetSafeQueryString(String, Boolean) |
Returns safe sql query string - escapes apostrophes and optionally escapes wildcard characters _, %, [].
|
| GetSelectQuery |
Gets the general select query
|
| GetSiteIDWhereCondition | Obsolete.
Returns the where condition for the give site ID.
|
| GetSqlValue |
Gets the value representation for a SQL query text
|
| GetValueExpression |
Gets the value expression from the given expression
|
| GetViewName |
Gets view name for specified table name.
|
| GetWhereCondition(String, Int32) | Obsolete.
Creates the where condition for the array of values.
|
| GetWhereCondition(String, IEnumerableString, Boolean) |
Creates the where condition for the array of values.
|
| GetWhereCondition(String, IListInt32, Boolean) |
Creates the where condition for the array of values.
|
| GetWhereConditionT(String, IEnumerableString, Boolean, Boolean) |
Creates the where condition for the array of values.
|
| GetWhereInConditionT |
Returns where condition in SQL syntax for collection of items.
|
| HandleEmptyColumns |
Handles the empty columns constant by replacing it with empty string
|
| IntersectQueries |
Returns the query created as an INTERSECT of the given queries.
|
| IsMissing |
Returns true if the given value is missing or null.
|
| IsMissingOrNull |
Returns true if the given value is missing or null.
|
| IsSingleColumn |
Returns true, if the query output is a single column
|
| JoinColumnList |
Joins the given column list. Columns are separated by comma.
|
| MatchLikePattern |
Indicates whether string matches given SQL 'like' pattern.
|
| MergeColumns(IEnumerableString, IEnumerableString, FuncString, String, Boolean, FuncString, String) |
Merges the sets of columns and makes sure that each column in the result is present only once.
|
| MergeColumns(String, String, FuncString, String, Boolean, FuncString, String) |
Merges the sets of columns and makes sure that each column in the result is present only once.
|
| ObjectsEqual |
Returns true if two objects are equal.
|
| OrderByContains |
Returns true if the order by expression contains column sorted the specified way.
|
| ParseColumn |
Gets the column name from the given SQL column expression
|
| ParseColumnList |
Parses the given list of columns to a list (can handle also advanced columns containing functions like ISNULL(A, B) etc.).
|
| ParseList |
Gets the SQL expression to get a parsed list of data
|
| ParseOrderBy | Obsolete.
Parses order by expression and returns list of columns
|
| PreparePagedQuery |
Prepares the query for paging, adds additional system columns and updates the columns list.
|
| PreprocessQuery |
Preprocesses the give query.
|
| ProcessPagedResults |
Processes the page results - Removes the system columns and gets the total records number.
|
| QueriesEqual |
Returns true if two queries equal by their content. Ignores extra whitespaces and comments within the comparison
|
| RemoveComments |
Removes single line and simple multiline comments from a SQL query
|
| RemoveOwner |
Removes the owner from the given object name.
|
| ReverseOrderBy |
Reverses the order by string by toggling between ASC and DESC.
|
| UnionQueries(String) |
Returns the query created as an UNION ALL of given queries.
|
| UnionQueries(String, Boolean) |
Returns the query created as an UNION of the given queries.
|
See Also