DbCommand

Overview

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

Location

Implements

 

constructor    (declared in Object) UIKit for Mac

Default constructor.

 

constructor

 

DbCommand()

 

init()

 

DbCommand()

 

Sub New()

AddParameter (String, Object) Android, iOS, iOS Simulator, Mac Catalyst, macOS, tvOS, tvOS Simulator, Ubuntu, watchOS, watchOS Simulator, WebAssembly, Windows

 

method AddParameter(aName: String; aValue: Object)

 

void AddParameter(String aName, Object aValue)

 

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

 

void AddParameter(String aName, Object aValue)

 

Sub AddParameter(aName As String, aValue As Object)

Parameters:

  • aName:
  • aValue:

AddParameter (String, Object) UIKit for Mac

Add a parameter to this command.

 

method AddParameter(aName: String; aValue: Object)

 

AddParameter(String aName, Object aValue)

 

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

 

AddParameter(String aName, Object aValue)

 

Sub AddParameter(aName As String, aValue As Object)

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 UIKit for Mac

Dispose this class.

 

method Dispose

 

Dispose()

 

func Dispose()

 

Dispose()

 

Sub Dispose()

Equals (Object): Boolean  virtual    (declared in Object) Android, iOS, iOS Simulator, Mac Catalyst, macOS, tvOS, tvOS Simulator, Ubuntu, watchOS, watchOS Simulator, WebAssembly, Windows

 

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:

Equals (Object): Boolean  virtual    (declared in Object) UIKit for Mac

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)

 

Function Equals(obj As Object) As Boolean

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

 

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) UIKit for Mac

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

 

Finalize()

 

func Finalize()

 

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 UIKit for Mac

Prepare this query.

 

method Prepare

 

Prepare()

 

func Prepare()

 

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) UIKit for Mac

Default constructor.

 

constructor

 

DbCommand()

 

init()

 

DbCommand()

 

Sub New()

AddParameter (String, Object) Android, iOS, iOS Simulator, Mac Catalyst, macOS, tvOS, tvOS Simulator, Ubuntu, watchOS, watchOS Simulator, WebAssembly, Windows

 

method AddParameter(aName: String; aValue: Object)

 

void AddParameter(String aName, Object aValue)

 

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

 

void AddParameter(String aName, Object aValue)

 

Sub AddParameter(aName As String, aValue As Object)

Parameters:

  • aName:
  • aValue:

AddParameter (String, Object) UIKit for Mac

Add a parameter to this command.

 

method AddParameter(aName: String; aValue: Object)

 

AddParameter(String aName, Object aValue)

 

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

 

AddParameter(String aName, Object aValue)

 

Sub AddParameter(aName As String, aValue As Object)

Parameters:

  • aName:
  • aValue:

Dispose  virtual abstract UIKit for Mac

Dispose this class.

 

method Dispose

 

Dispose()

 

func Dispose()

 

Dispose()

 

Sub Dispose()

Equals (Object): Boolean  virtual    (declared in Object) Android, iOS, iOS Simulator, Mac Catalyst, macOS, tvOS, tvOS Simulator, Ubuntu, watchOS, watchOS Simulator, WebAssembly, Windows

 

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:

Equals (Object): Boolean  virtual    (declared in Object) UIKit for Mac

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)

 

Function Equals(obj As Object) As Boolean

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

 

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) UIKit for Mac

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

 

Finalize()

 

func Finalize()

 

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 UIKit for Mac

Prepare this query.

 

method Prepare

 

Prepare()

 

func Prepare()

 

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