SqlParametersParser

Overview

Location

 

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 array of 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 array of 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 array of 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 array of 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 array of 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 array of Char, textDelimiter As Char) As String

Parameters:

  • sql:
  • parameterSymbol:
  • quoteSymbols:
  • textDelimiter: