The SqlHelper type exposes the following members.
Back to Top
Back to Top
Back to Top
Methods
| Name | Description | |
|---|---|---|
  | AddColumnAlias |
Adds the column alias to the given expression
|
| AddColumns |
Adds the columns.
|
| AddOrderBy |
Adds the order by to en existing one.
|
| AddWhereCondition(String, String) |
Adds where condition to the expression using AND operator.
|
| AddWhereCondition(String, String, String) |
Adds where condition to the expression.
|
| EnsureFullName |
Ensures full name of the given column
|
| EnsureMissingColumns(ICollection List String ) |
Ensures the missing columns in the given lists of columns
|
| EnsureMissingColumns(IList String ) |
Ensures the missing columns in the given lists of columns
|
| EnsureOrderByColumns |
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.
|
| GetAliasPathCondition |
Returns the where condition for node alias path expression.
|
| GetBetween |
Gets the condition matching values of the column between from and to
|
| 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(IEnumerable String ) |
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.
|
| GetColumnName |
Gets the column name from the given SQL column expression
|
| GetData |
Gets the data from the DataSet
|
| GetDBSchema |
Returns DB object scheme from settings.
|
| GetDBSchemaOrDefault |
Returns DB object scheme from settings or default value.
|
| 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
|
| GetPagedQuery |
Gets the query by its name and validates the query for paging
|
| GetParamCacheString |
Gets the parameters string.
|
| GetParameterName |
Gets the parameter name
|
| GetParamString |
Gets the parameters string.
|
| GetResultsString |
Gets the results as a string for log.
|
| 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 |
Returns the where condition for the give site ID.
|
| GetSqlValue |
Gets the value representation for a SQL query text
|
| GetViewName |
Gets view name for specified table name.
|
| GetWhereCondition(String, IEnumerable String ) |
Creates the where condition for the array of values.
|
| GetWhereCondition(String, IList Int32 ) |
Creates the where condition for the array of values.
|
| GetWhereCondition(String, Int32) |
Creates the where condition for the array of values.
|
| GetWhereCondition(String, IEnumerable String , Boolean) |
Creates the where condition for the array of values.
|
| GetWhereCondition(String, IList Int32 , Boolean) |
Creates the where condition for the array of values.
|
| GetWhereCondition T (String, IEnumerable String , Boolean) |
Creates the where condition for the array of values.
|
| GetWhereCondition T (String, IEnumerable String , Boolean, Boolean) |
Creates the where condition for the array of values.
|
| HandleEmptyColumns |
Handles the empty columns constant by replacing it with empty string
|
| 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.
|
| MergeColumns(IEnumerable String , IEnumerable String , Func String, String , Boolean, Func String, String ) |
Merges the sets of columns and makes sure that each column in the result is present only once.
|
| MergeColumns(String, String, Func String, String , Boolean, Func String, 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.
|
| ParseColumnList |
Parses the given list of columns to a list (can handle also advanced columns containing functions like ISNULL(A, B) etc.).
|
| ParseOrderBy |
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 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 of given queries.
|
| UnionQueries( String , Boolean) |
Returns the query created as an union of given queries.
|
Fields
| Name | Description | |
|---|---|---|
 | COLUMNS_ALL |
Represents all columns within given query
|
| CommentsRegEx |
Regex matching comments within a SQL query
|
| DEFAULT_DB_SCHEMA |
Default db schema.
|
| GENERAL_SELECT |
General select SQL statement
|
| IsWildCardRegEx |
Regex matching the wildcard within alias path.
|
| MAX_PARAM_LENGTH |
Maximum parameter length to log.
|
| MISSING_VALUE |
Unknown value.
|
| NO_COLUMNS |
Constant for no columns.
|
| NO_DATA_WHERE |
Where condition representing no data.
|
| NO_TOTALRECORDS |
Value for total records input to not get the total amount of data.
|
| ORDERBY_ASC |
Suffix for the ascending order
|
| ORDERBY_DESC |
Suffix for the descending order
|
| RemoveWildCardRegEx |
Regex for matching the escaped content within alias path.
|
Properties
| Name | Description | |
|---|---|---|
 | RunningQueries |
Counter of running queries.
|
See Also