Kentico 12 Service Pack API Reference
Namespaces
CMS Namespaces
CMS.DataEngine Namespaces
CMS.DataEngine
SqlHelper Class
SqlHelper Methods
AddColumnAlias Method
AddColumns Method
AddOrderBy Method
AddWhereCondition Method
AppendQuery Method
ApplyOver Method
BuildBigIntTable Method
BuildGuidTable Method
BuildIntTable Method
BuildOrderedIntTable Method
BuildStringTable Method
CombineQueries Method
EnsureFullName Method
EnsureMissingColumns Method
EscapeLikeQueryPatterns Method
EscapeLikeText Method
EscapeQuotes Method
ExceptQueries Method
GetAggregation Method
GetBetween Method
GetCase Method
GetCaseColumn Method
GetCaseOrderBy Method
GetCast Method
GetColumnName Method
GetComment Method
GetConvert Method
GetDBSchemaOrDefault Method
GetIsNumeric Method
GetJoin Method
GetJoinType Method
GetNestedQuery Method
GetOrderByColumnName Method
GetParamCacheString Method
GetParameterName Method
GetParamString Method
GetResultsString Method
GetRound Method
GetRowNumber Method
GetSafeOwner Method
GetSafeQueryString Method
GetSelectQuery Method
GetSqlValue Method
GetValueExpression Method
GetWhereCondition Method
GetWhereInCondition(T) Method
HandleEmptyColumns Method
IntersectQueries Method
IsMissing Method
IsMissingOrNull Method
IsSingleColumn Method
JoinColumnList Method
MatchLikePattern Method
MergeColumns Method
ObjectsEqual Method
OrderByContains Method
ParseColumn Method
ParseColumnList Method
PreparePagedQuery Method
PreprocessQuery Method
ProcessPagedResults Method
QueriesEqual Method
RemoveComments Method
RemoveOwner Method
ReverseOrderBy Method
UnionQueries Method
Click or drag to resize
SqlHelperQueriesEqual Method
Returns true if two queries equal by their content. Ignores extra whitespaces and comments within the comparison

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntax
C#
Copy
public static bool QueriesEqual(
	ref string query1,
	ref string query2,
	bool returnDifference = false
)

Parameters

query1
Type: SystemString
First query
query2
Type: SystemString
Second query
returnDifference (Optional)
Type: SystemBoolean
If true, the difference (remainders that don't match) are returned through original values

Return Value

Type: Boolean
Exceptions
ExceptionCondition
ArgumentNullExceptionWhen query parameter is null
See Also