DbCommand

Overview

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

Location

  • Reference: Island.fx
  • Namespace: RemObjects.Elements.System
  • Platforms: Android, iOS, iOS Simulator, macOS, tvOS, tvOS Simulator, Ubuntu, UIKit for Mac, watchOS Simulator, watchOS-arm64_32, watchOS-armv7k, WebAssembly, Windows

Implements

 

constructor    (declared in Object)

Default constructor.

 

constructor

 

DbCommand()

 

init()

 

DbCommand()

AddParameter

Add a parameter to this command.

 

method AddParameter(aName: String; aValue: Object)

 

void AddParameter(String aName, Object aValue)

 

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

 

void AddParameter(String aName, Object aValue)

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; }

Dispose  virtual abstract

Dispose this class.

 

method Dispose

 

void Dispose()

 

func Dispose()

 

void Dispose()

Equals  virtual    (declared in Object)

Returns true if the target object matches this one, by default compares the reference.

 

method Equals(obj: Object): Boolean

 

Boolean Equals(Object obj)

 

func Equals(_ obj: Object) -> Boolean

 

Boolean Equals(Object obj)

Parameters:

  • obj: 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()

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()

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()

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()

Finalize  protected virtual    (declared in Object)

Finalizer implementation. If not overriden it's not called at all, the runtime checks if there is an override before calling a finalizer.

 

method Finalize

 

void Finalize()

 

func Finalize()

 

void 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()

GetType    (declared in Object)

Returns the actual type of this class

 

method GetType: Type

 

Type GetType()

 

func GetType() -> Type

 

Type GetType()

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; }

Prepare  virtual abstract

Prepare this query.

 

method Prepare

 

void Prepare()

 

func Prepare()

 

void 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)

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()

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; }

 

Command

Contains the command string.

 

property Command: String read write;

 

String Command { get; set; }

 

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

 

String Command { __get; __set; }

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; }

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; }

 

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)

Parameters:

  • a: left value
  • b: right value

 

constructor    (declared in Object)

Default constructor.

 

constructor

 

DbCommand()

 

init()

 

DbCommand()

AddParameter

Add a parameter to this command.

 

method AddParameter(aName: String; aValue: Object)

 

void AddParameter(String aName, Object aValue)

 

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

 

void AddParameter(String aName, Object aValue)

Parameters:

  • aName:
  • aValue:

Dispose  virtual abstract

Dispose this class.

 

method Dispose

 

void Dispose()

 

func Dispose()

 

void Dispose()

Equals  virtual    (declared in Object)

Returns true if the target object matches this one, by default compares the reference.

 

method Equals(obj: Object): Boolean

 

Boolean Equals(Object obj)

 

func Equals(_ obj: Object) -> Boolean

 

Boolean Equals(Object obj)

Parameters:

  • obj: 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()

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()

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()

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()

Finalize  protected virtual    (declared in Object)

Finalizer implementation. If not overriden it's not called at all, the runtime checks if there is an override before calling a finalizer.

 

method Finalize

 

void Finalize()

 

func Finalize()

 

void 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()

GetType    (declared in Object)

Returns the actual type of this class

 

method GetType: Type

 

Type GetType()

 

func GetType() -> Type

 

Type GetType()

Prepare  virtual abstract

Prepare this query.

 

method Prepare

 

void Prepare()

 

func Prepare()

 

void Prepare()

ToString  virtual    (declared in Object)

Gets the string representation of this method.

 

method ToString: String

 

String ToString()

 

func ToString() -> String

 

String ToString()