SqlParametersParser
Overview
Location
- Reference: RemObjects.DataAbstract.Server.dll
- Namespace: RemObjects.DataAbstract.Server
constructor
constructor
SqlParametersParser()
Sub New()
AddPrefix
class method AddPrefix(name: String; prefix: String): String
static String AddPrefix(String name, String prefix)
Shared Function AddPrefix(name As String, prefix As String) As String
Parameters:
- name:
- prefix:
GetParameterNames
method GetParameterNames(sql: String; parameterSymbol: Char; quoteSymbols: array of Char; textDelimiter: Char; caseInsensitive: Boolean; extractUniqueNamesOnly: Boolean): IList<String>
IList<String> GetParameterNames(String sql, Char parameterSymbol, Char[] quoteSymbols, Char textDelimiter, Boolean caseInsensitive, Boolean extractUniqueNamesOnly)
Function GetParameterNames(sql As String, parameterSymbol As Char, quoteSymbols As Char(), textDelimiter As Char, caseInsensitive As Boolean, extractUniqueNamesOnly As Boolean) As IList<String>
Parameters:
- sql:
- parameterSymbol:
- quoteSymbols:
- textDelimiter:
- caseInsensitive:
- extractUniqueNamesOnly:
RemovePrefix
class method RemovePrefix(name: String; prefix: String): String
static String RemovePrefix(String name, String prefix)
Shared Function RemovePrefix(name As String, prefix As String) As String
Parameters:
- name:
- prefix:
ReplaceParameterSymbol
method ReplaceParameterSymbol(sql: String; parameterSymbol: Char; textDelimiter: Char): String
String ReplaceParameterSymbol(String sql, Char parameterSymbol, Char textDelimiter)
Function ReplaceParameterSymbol(sql As String, parameterSymbol As Char, textDelimiter As Char) As String
Parameters:
- sql:
- parameterSymbol:
- textDelimiter:
ReplaceSequentialParameters
method ReplaceSequentialParameters(sql: String; parameterNames: IList<String>; parameterSymbol: Char; quoteSymbols: array of Char; textDelimiter: Char; parameterPlaceholder: String): String
String ReplaceSequentialParameters(String sql, IList<String> parameterNames, Char parameterSymbol, Char[] quoteSymbols, Char textDelimiter, String parameterPlaceholder)
Function ReplaceSequentialParameters(sql As String, parameterNames As IList<String>, parameterSymbol As Char, quoteSymbols As Char(), textDelimiter As Char, parameterPlaceholder As String) As String
Parameters:
- sql:
- parameterNames:
- parameterSymbol:
- quoteSymbols:
- textDelimiter:
- parameterPlaceholder:
SetDefaultParameterValues
method SetDefaultParameterValues(sql: String; parameterSymbol: Char; quoteSymbols: array of Char; textDelimiter: Char): String
String SetDefaultParameterValues(String sql, Char parameterSymbol, Char[] quoteSymbols, Char textDelimiter)
Function SetDefaultParameterValues(sql As String, parameterSymbol As Char, quoteSymbols As Char(), textDelimiter As Char) As String
Parameters:
- sql:
- parameterSymbol:
- quoteSymbols:
- textDelimiter:
AddPrefix
class method AddPrefix(name: String; prefix: String): String
static String AddPrefix(String name, String prefix)
Shared Function AddPrefix(name As String, prefix As String) As String
Parameters:
- name:
- prefix:
RemovePrefix
class method RemovePrefix(name: String; prefix: String): String
static String RemovePrefix(String name, String prefix)
Shared Function RemovePrefix(name As String, prefix As String) As String
Parameters:
- name:
- prefix:
constructor
constructor
SqlParametersParser()
Sub New()
GetParameterNames
method GetParameterNames(sql: String; parameterSymbol: Char; quoteSymbols: array of Char; textDelimiter: Char; caseInsensitive: Boolean; extractUniqueNamesOnly: Boolean): IList<String>
IList<String> GetParameterNames(String sql, Char parameterSymbol, Char[] quoteSymbols, Char textDelimiter, Boolean caseInsensitive, Boolean extractUniqueNamesOnly)
Function GetParameterNames(sql As String, parameterSymbol As Char, quoteSymbols As Char(), textDelimiter As Char, caseInsensitive As Boolean, extractUniqueNamesOnly As Boolean) As IList<String>
Parameters:
- sql:
- parameterSymbol:
- quoteSymbols:
- textDelimiter:
- caseInsensitive:
- extractUniqueNamesOnly:
ReplaceParameterSymbol
method ReplaceParameterSymbol(sql: String; parameterSymbol: Char; textDelimiter: Char): String
String ReplaceParameterSymbol(String sql, Char parameterSymbol, Char textDelimiter)
Function ReplaceParameterSymbol(sql As String, parameterSymbol As Char, textDelimiter As Char) As String
Parameters:
- sql:
- parameterSymbol:
- textDelimiter:
ReplaceSequentialParameters
method ReplaceSequentialParameters(sql: String; parameterNames: IList<String>; parameterSymbol: Char; quoteSymbols: array of Char; textDelimiter: Char; parameterPlaceholder: String): String
String ReplaceSequentialParameters(String sql, IList<String> parameterNames, Char parameterSymbol, Char[] quoteSymbols, Char textDelimiter, String parameterPlaceholder)
Function ReplaceSequentialParameters(sql As String, parameterNames As IList<String>, parameterSymbol As Char, quoteSymbols As Char(), textDelimiter As Char, parameterPlaceholder As String) As String
Parameters:
- sql:
- parameterNames:
- parameterSymbol:
- quoteSymbols:
- textDelimiter:
- parameterPlaceholder:
SetDefaultParameterValues
method SetDefaultParameterValues(sql: String; parameterSymbol: Char; quoteSymbols: array of Char; textDelimiter: Char): String
String SetDefaultParameterValues(String sql, Char parameterSymbol, Char[] quoteSymbols, Char textDelimiter)
Function SetDefaultParameterValues(sql As String, parameterSymbol As Char, quoteSymbols As Char(), textDelimiter As Char) As String
Parameters:
- sql:
- parameterSymbol:
- quoteSymbols:
- textDelimiter: