DbCommand

Overview

Command object for databases. Use this to store parameters and a query and execute it or get the results.

Location


 

constructor    (declared in Object)

 

constructor

 

DbCommand()

 

init()

 

DbCommand()

 

Sub New()

AddParameter

 

method AddParameter(aName: String; aValue: Object := nil)

 

void AddParameter(String aName, Object aValue = null)

 

func AddParameter(_ aName: String, _ aValue: Object = nil)

 

void AddParameter(String aName, Object aValue)

 

Sub AddParameter(aName As String, aValue As Object = Null)

Parameters:

  • aName:
  • aValue:

Command

Contains the command string.

 

property Command: String read write;

 

String Command { get; set; }

 

var Command: String { get{} set{} }

 

String Command { __get; __set; }

 

Property Command() As String

Dispose  virtual abstract

 

method Dispose

 

void Dispose()

 

func Dispose()

 

void Dispose()

 

Sub Dispose()

Equals  virtual    (declared in Object)

Default constructor.

 

method Equals(aOther: Object): Boolean

 

Boolean Equals(Object aOther)

 

func Equals(_ aOther: Object) -> Boolean

 

Boolean Equals(Object aOther)

 

Function Equals(aOther As Object) As Boolean

Parameters:

  • aOther: the reference to compare this with.

ExecuteNonQuery  virtual abstract

Execute this command, returning the number of rows affected.

 

method ExecuteNonQuery: Int32

 

Int32 ExecuteNonQuery()

 

func ExecuteNonQuery() -> Int32

 

Int32 ExecuteNonQuery()

 

Function ExecuteNonQuery() As Int32

ExecuteNonQueryAsync  virtual

Execute this command, returning the number of rows affected, asynchronously.

 

method ExecuteNonQueryAsync: Task<Int32>

 

Task<Int32> ExecuteNonQueryAsync()

 

func ExecuteNonQueryAsync() -> Task<Int32>

 

Task<Int32> ExecuteNonQueryAsync()

 

Function ExecuteNonQueryAsync() As Task<Int32>

ExecuteReader  virtual abstract

Executes this command and return a reader object to get the values.

 

method ExecuteReader: DbDataReader

 

DbDataReader ExecuteReader()

 

func ExecuteReader() -> DbDataReader

 

DbDataReader ExecuteReader()

 

Function ExecuteReader() As DbDataReader

ExecuteReaderAsync  virtual

Executes this command and return a reader object to get the values asynchronously.

 

method ExecuteReaderAsync: Task<DbDataReader>

 

Task<DbDataReader> ExecuteReaderAsync()

 

func ExecuteReaderAsync() -> Task<DbDataReader>

 

Task<DbDataReader> ExecuteReaderAsync()

 

Function ExecuteReaderAsync() As Task<DbDataReader>

Finalize  protected virtual    (declared in Object)

 

method Finalize

 

void Finalize()

 

func Finalize()

 

void Finalize()

 

Sub Finalize()

GetHashCode  virtual    (declared in Object)

Returns a hashcode for this object. Overriden implementations should make sure that the number returned here is constant given the same object.

 

method GetHashCode: Int32

 

Int32 GetHashCode()

 

func GetHashCode() -> Int32

 

Int32 GetHashCode()

 

Function GetHashCode() As Int32

GetType    (declared in Object)

Returns the actual type of this class

 

method GetType: Type

 

Type GetType()

 

func GetType() -> Type

 

Type GetType()

 

Function GetType() As Type

Parameters

Contains a list of parameters for this query.

 

property Parameters: List<DbParameter> read;

 

List<DbParameter> Parameters { get; }

 

var Parameters: List<DbParameter> { get{} }

 

List<DbParameter> Parameters { __get; }

 

ReadOnly Property Parameters() As List<DbParameter>

Prepare  virtual abstract

 

method Prepare

 

void Prepare()

 

func Prepare()

 

void Prepare()

 

Sub Prepare()

ReferenceEquals    (declared in Object)

Compares two references for equivalence (even if they have an equals operator)

 

class method ReferenceEquals(a: Object; b: Object): Boolean

 

static Boolean ReferenceEquals(Object a, Object b)

 

static func ReferenceEquals(_ a: Object, _ b: Object) -> Boolean

 

static Boolean ReferenceEquals(Object a, Object b)

 

Shared Function ReferenceEquals(a As Object, b As Object) As Boolean

Parameters:

  • a: left value
  • b: right value

ToString  virtual    (declared in Object)

Gets the string representation of this method.

 

method ToString: String

 

String ToString()

 

func ToString() -> String

 

String ToString()

 

Function ToString() As String

Transaction

Holds the transaction for this command.

 

property Transaction: DbTransaction read write;

 

DbTransaction Transaction { get; set; }

 

var Transaction: DbTransaction { get{} set{} }

 

DbTransaction Transaction { __get; __set; }

 

Property Transaction() As DbTransaction

 

Command

Contains the command string.

 

property Command: String read write;

 

String Command { get; set; }

 

var Command: String { get{} set{} }

 

String Command { __get; __set; }

 

Property Command() As String

Parameters

Contains a list of parameters for this query.

 

property Parameters: List<DbParameter> read;

 

List<DbParameter> Parameters { get; }

 

var Parameters: List<DbParameter> { get{} }

 

List<DbParameter> Parameters { __get; }

 

ReadOnly Property Parameters() As List<DbParameter>

Transaction

Holds the transaction for this command.

 

property Transaction: DbTransaction read write;

 

DbTransaction Transaction { get; set; }

 

var Transaction: DbTransaction { get{} set{} }

 

DbTransaction Transaction { __get; __set; }

 

Property Transaction() As DbTransaction

 

ReferenceEquals    (declared in Object)

Compares two references for equivalence (even if they have an equals operator)

 

class method ReferenceEquals(a: Object; b: Object): Boolean

 

static Boolean ReferenceEquals(Object a, Object b)

 

static func ReferenceEquals(_ a: Object, _ b: Object) -> Boolean

 

static Boolean ReferenceEquals(Object a, Object b)

 

Shared Function ReferenceEquals(a As Object, b As Object) As Boolean

Parameters:

  • a: left value
  • b: right value

 

constructor    (declared in Object)

 

constructor

 

DbCommand()

 

init()

 

DbCommand()

 

Sub New()

AddParameter

 

method AddParameter(aName: String; aValue: Object := nil)

 

void AddParameter(String aName, Object aValue = null)

 

func AddParameter(_ aName: String, _ aValue: Object = nil)

 

void AddParameter(String aName, Object aValue)

 

Sub AddParameter(aName As String, aValue As Object = Null)

Parameters:

  • aName:
  • aValue:

Dispose  virtual abstract

 

method Dispose

 

void Dispose()

 

func Dispose()

 

void Dispose()

 

Sub Dispose()

Equals  virtual    (declared in Object)

Default constructor.

 

method Equals(aOther: Object): Boolean

 

Boolean Equals(Object aOther)

 

func Equals(_ aOther: Object) -> Boolean

 

Boolean Equals(Object aOther)

 

Function Equals(aOther As Object) As Boolean

Parameters:

  • aOther: the reference to compare this with.

ExecuteNonQuery  virtual abstract

Execute this command, returning the number of rows affected.

 

method ExecuteNonQuery: Int32

 

Int32 ExecuteNonQuery()

 

func ExecuteNonQuery() -> Int32

 

Int32 ExecuteNonQuery()

 

Function ExecuteNonQuery() As Int32

ExecuteNonQueryAsync  virtual

Execute this command, returning the number of rows affected, asynchronously.

 

method ExecuteNonQueryAsync: Task<Int32>

 

Task<Int32> ExecuteNonQueryAsync()

 

func ExecuteNonQueryAsync() -> Task<Int32>

 

Task<Int32> ExecuteNonQueryAsync()

 

Function ExecuteNonQueryAsync() As Task<Int32>

ExecuteReader  virtual abstract

Executes this command and return a reader object to get the values.

 

method ExecuteReader: DbDataReader

 

DbDataReader ExecuteReader()

 

func ExecuteReader() -> DbDataReader

 

DbDataReader ExecuteReader()

 

Function ExecuteReader() As DbDataReader

ExecuteReaderAsync  virtual

Executes this command and return a reader object to get the values asynchronously.

 

method ExecuteReaderAsync: Task<DbDataReader>

 

Task<DbDataReader> ExecuteReaderAsync()

 

func ExecuteReaderAsync() -> Task<DbDataReader>

 

Task<DbDataReader> ExecuteReaderAsync()

 

Function ExecuteReaderAsync() As Task<DbDataReader>

Finalize  protected virtual    (declared in Object)

 

method Finalize

 

void Finalize()

 

func Finalize()

 

void Finalize()

 

Sub Finalize()

GetHashCode  virtual    (declared in Object)

Returns a hashcode for this object. Overriden implementations should make sure that the number returned here is constant given the same object.

 

method GetHashCode: Int32

 

Int32 GetHashCode()

 

func GetHashCode() -> Int32

 

Int32 GetHashCode()

 

Function GetHashCode() As Int32

GetType    (declared in Object)

Returns the actual type of this class

 

method GetType: Type

 

Type GetType()

 

func GetType() -> Type

 

Type GetType()

 

Function GetType() As Type

Prepare  virtual abstract

 

method Prepare

 

void Prepare()

 

func Prepare()

 

void Prepare()

 

Sub Prepare()

ToString  virtual    (declared in Object)

Gets the string representation of this method.

 

method ToString: String

 

String ToString()

 

func ToString() -> String

 

String ToString()

 

Function ToString() As String