ServerConnection.NormalizeQuery Method

Definition

Overloads

NormalizeQuery(String, Boolean)

Translate a query with embedded literals to a normalized form (all literals replaced by a standard token)

NormalizeQuery(String)

Overload for the above function -- see it for details

NormalizeQuery(String, Boolean)

Translate a query with embedded literals to a normalized form (all literals replaced by a standard token)

public static string NormalizeQuery (string QueryText, bool QuotedIdentifiers);
static member NormalizeQuery : string * bool -> string
Public Shared Function NormalizeQuery (QueryText As String, QuotedIdentifiers As Boolean) As String

Parameters

QueryText
String

Query text to normalize

QuotedIdentifiers
Boolean

Switch indicating whether query text expects QUOTED_IDENTIFER to be enabled

Returns

Query text with inline literals translated to ? symbols

Remarks

Examples:

SELECT * FROM table WHERE column = 123

becomes:

SELECT * FROM table WHERE column = ?

SELECT * FROM table WHERE column = 'foo'

becomes:

SELECT * FROM table WHERE column = '?'

Applies to

NormalizeQuery(String)

Overload for the above function -- see it for details

public static string NormalizeQuery (string QueryText);
static member NormalizeQuery : string -> string
Public Shared Function NormalizeQuery (QueryText As String) As String

Parameters

QueryText
String

Returns

Applies to