Click or drag to resize
SqlHelper Methods

The SqlHelper type exposes the following members.

Methods
  NameDescription
Public methodStatic memberAddColumnAlias
Adds the column alias to the given expression
Public methodStatic memberAddColumns
Adds the columns.
Public methodStatic memberAddOrderBy
Adds the order by to an existing one.
Public methodStatic memberAddWhereCondition(String, String)
Adds where condition to the expression using AND operator.
Public methodStatic memberAddWhereCondition(String, String, String)
Adds where condition to the expression.
Public methodStatic memberAppendQuery
Combines the given queries with the operator
Public methodStatic memberApplyOver
Applies the over clause to the given expression
Public methodStatic memberCode exampleBuildIntList
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.
Public methodStatic memberBuildIntTable
Gets a table-valued parameter for database calls. Is intended for usage with CMS_Type_Integers database type.
Public methodStatic memberCombineQueries
Combines the given queries with the operators
Public methodStatic memberEnsureFullName
Ensures full name of the given column
Public methodStatic memberEnsureMissingColumns(ICollectionListString) Obsolete.
Ensures the missing columns in the given lists of columns
Public methodStatic memberEnsureMissingColumns(IListString) Obsolete.
Ensures the missing columns in the given lists of columns
Public methodStatic memberEnsureMissingColumns(ICollectionQueryColumnList)
Ensures the missing columns in the given collection of QueryColumnList instances
Public methodStatic memberEnsureOrderByColumns 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
Public methodStatic memberEscapeLikeQueryPatterns
Escapes characters for query which use LIKE pattern.
Public methodStatic memberEscapeLikeText
Escapes characters for query which use LIKE pattern (%, _, [, ] and ^).
Public methodStatic memberEscapeQuotes
Escapes single quotes in string value used for SQL query (value's => value''s).
Public methodStatic memberExceptQueries
Returns the query created as an EXCEPT of the given queries.
Public methodStatic memberGetAggregation
Gets the aggregation expression from the given expression
Public methodStatic memberGetBetween
Gets the condition matching values of the column between from and to
Public methodStatic memberGetCase
Returns statement for the CASE expressions.
Public methodStatic memberGetCaseColumn
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.
Public methodStatic memberGetCaseOrderBy(IEnumerableString)
Returns order by statement based on case boolean expressions. First case has highest priority.
Public methodStatic memberGetCaseOrderBy(String)
Returns order by statement based on case boolean expressions. First case has highest priority.
Public methodStatic memberCode exampleGetCast
Get the CAST expression.
Public methodStatic memberGetColumnName
Gets the column name from the given SQL column expression
Public methodStatic memberGetComment
Gets a multiline SQL comment for simple input text (must not contain any open comment sequence)
Public methodStatic memberCode exampleGetConvert
Gets the convert expression.
Public methodStatic memberGetDBSchema
Returns DB object scheme from settings.
Public methodStatic memberGetDBSchemaOrDefault
Returns DB object scheme from settings or default value.
Public methodStatic memberCode exampleGetIsNumeric
Gets the ISNUMERIC expression.
Public methodStatic memberGetJoin
Gets the join expression
Public methodStatic memberGetJoinType
Gets the join expression
Public methodStatic memberGetNestedQuery
Gets a nested query using nested SELECT for further evaluation
Public methodStatic memberGetOrderByColumnName(String)
Gets the column name from the given SQL column expression
Public methodStatic memberGetOrderByColumnName(String, String)
Gets the column name from the given SQL column expression
Public methodStatic memberGetParamCacheString
Gets the parameters string.
Public methodStatic memberGetParameterName
Gets the parameter name
Public methodStatic memberGetParamString
Gets the parameters string.
Public methodStatic memberGetResultsString
Gets the results as a string for log.
Public methodStatic memberGetRound
Gets the round expression
Public methodStatic memberGetRowNumber
Gets the row number expression
Public methodStatic memberGetSafeOwner
Returns safe string representing DB owner.
Public methodStatic memberGetSafeQueryString(String)
Returns safe sql query string - escapes apostrophes and escapes wildcard characters _, %, [].
Public methodStatic memberGetSafeQueryString(String, Boolean)
Returns safe sql query string - escapes apostrophes and optionally escapes wildcard characters _, %, [].
Public methodStatic memberGetSelectQuery
Gets the general select query
Public methodStatic memberGetSiteIDWhereCondition Obsolete.
Returns the where condition for the give site ID.
Public methodStatic memberGetSqlValue
Gets the value representation for a SQL query text
Public methodStatic memberGetValueExpression
Gets the value expression from the given expression
Public methodStatic memberGetViewName
Gets view name for specified table name.
Public methodStatic memberGetWhereCondition(String, Int32) Obsolete.
Creates the where condition for the array of values.
Public methodStatic memberGetWhereCondition(String, IEnumerableString, Boolean)
Creates the where condition for the array of values.
Public methodStatic memberGetWhereCondition(String, IListInt32, Boolean)
Creates the where condition for the array of values.
Public methodStatic memberGetWhereConditionT(String, IEnumerableString, Boolean, Boolean)
Creates the where condition for the array of values.
Public methodStatic memberCode exampleGetWhereInConditionT
Returns where condition in SQL syntax for collection of items.
Public methodStatic memberHandleEmptyColumns
Handles the empty columns constant by replacing it with empty string
Public methodStatic memberIntersectQueries
Returns the query created as an INTERSECT of the given queries.
Public methodStatic memberIsMissing
Returns true if the given value is missing or null.
Public methodStatic memberIsMissingOrNull
Returns true if the given value is missing or null.
Public methodStatic memberIsSingleColumn
Returns true, if the query output is a single column
Public methodStatic memberJoinColumnList
Joins the given column list. Columns are separated by comma.
Public methodStatic memberMatchLikePattern
Indicates whether string matches given SQL 'like' pattern.
Public methodStatic memberMergeColumns(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.
Public methodStatic memberMergeColumns(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.
Public methodStatic memberObjectsEqual
Returns true if two objects are equal.
Public methodStatic memberOrderByContains
Returns true if the order by expression contains column sorted the specified way.
Public methodStatic memberParseColumn
Gets the column name from the given SQL column expression
Public methodStatic memberParseColumnList
Parses the given list of columns to a list (can handle also advanced columns containing functions like ISNULL(A, B) etc.).
Public methodStatic memberParseList
Gets the SQL expression to get a parsed list of data
Public methodStatic memberParseOrderBy Obsolete.
Parses order by expression and returns list of columns
Public methodStatic memberPreparePagedQuery
Prepares the query for paging, adds additional system columns and updates the columns list.
Public methodStatic memberPreprocessQuery
Preprocesses the give query.
Public methodStatic memberProcessPagedResults
Processes the page results - Removes the system columns and gets the total records number.
Public methodStatic memberQueriesEqual
Returns true if two queries equal by their content. Ignores extra whitespaces and comments within the comparison
Public methodStatic memberRemoveComments
Removes single line and simple multiline comments from a SQL query
Public methodStatic memberRemoveOwner
Removes the owner from the given object name.
Public methodStatic memberReverseOrderBy
Reverses the order by string by toggling between ASC and DESC.
Public methodStatic memberUnionQueries(String)
Returns the query created as an UNION ALL of given queries.
Public methodStatic memberUnionQueries(String, Boolean)
Returns the query created as an UNION of the given queries.
Top
See Also