Class MySqlCommand

Inheritance
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
System.Data.Common.DbCommand
MySqlCommand
Implements
System.ComponentModel.IComponent
System.Data.IDbCommand
System.IDisposable
Inherited Members
System.Data.Common.DbCommand.ExecuteNonQueryAsync()
System.Data.Common.DbCommand.ExecuteReaderAsync()
System.Data.Common.DbCommand.ExecuteReaderAsync(System.Data.CommandBehavior)
System.Data.Common.DbCommand.ExecuteReaderAsync(System.Data.CommandBehavior, System.Threading.CancellationToken)
System.Data.Common.DbCommand.ExecuteReaderAsync(System.Threading.CancellationToken)
System.Data.Common.DbCommand.ExecuteScalarAsync()
System.Data.Common.DbCommand.System.Data.IDbCommand.CreateParameter()
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(System.Data.CommandBehavior)
System.Data.Common.DbCommand.System.Data.IDbCommand.Connection
System.Data.Common.DbCommand.System.Data.IDbCommand.Parameters
System.Data.Common.DbCommand.System.Data.IDbCommand.Transaction
System.ComponentModel.Component.Dispose()
System.ComponentModel.Component.GetService(System.Type)
System.ComponentModel.Component.ToString()
System.ComponentModel.Component.CanRaiseEvents
System.ComponentModel.Component.Container
System.ComponentModel.Component.DesignMode
System.ComponentModel.Component.Events
System.ComponentModel.Component.Site
System.ComponentModel.Component.Disposed
System.MarshalByRefObject.GetLifetimeService()
System.MarshalByRefObject.InitializeLifetimeService()
System.MarshalByRefObject.MemberwiseClone(System.Boolean)
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
Namespace: MySql.Data.MySqlClient
Assembly: NFX.MySQL.dll
Syntax
public sealed class MySqlCommand : DbCommand, IComponent, IDbCommand, IDisposable

Constructors

MySqlCommand()

Declaration
public MySqlCommand()

MySqlCommand(MySqlConnection, MySqlTransaction)

Declaration
public MySqlCommand(MySqlConnection connection, MySqlTransaction transaction)
Parameters
Type Name Description
MySqlConnection connection
MySqlTransaction transaction

MySqlCommand(String)

Declaration
public MySqlCommand(string commandText)
Parameters
Type Name Description
System.String commandText

MySqlCommand(String, MySqlConnection)

Declaration
public MySqlCommand(string commandText, MySqlConnection connection)
Parameters
Type Name Description
System.String commandText
MySqlConnection connection

MySqlCommand(String, MySqlConnection, MySqlTransaction)

Declaration
public MySqlCommand(string commandText, MySqlConnection connection, MySqlTransaction transaction)
Parameters
Type Name Description
System.String commandText
MySqlConnection connection
MySqlTransaction transaction

Properties

CommandText

Declaration
public override string CommandText { get; set; }
Property Value
Type Description
System.String
Overrides
System.Data.Common.DbCommand.CommandText

CommandTimeout

Declaration
public override int CommandTimeout { get; set; }
Property Value
Type Description
System.Int32
Overrides
System.Data.Common.DbCommand.CommandTimeout

CommandType

Declaration
public override CommandType CommandType { get; set; }
Property Value
Type Description
System.Data.CommandType
Overrides
System.Data.Common.DbCommand.CommandType

Connection

Declaration
public MySqlConnection Connection { get; set; }
Property Value
Type Description
MySqlConnection

DbConnection

Declaration
protected override DbConnection DbConnection { get; set; }
Property Value
Type Description
System.Data.Common.DbConnection
Overrides
System.Data.Common.DbCommand.DbConnection

DbParameterCollection

Declaration
protected override DbParameterCollection DbParameterCollection { get; }
Property Value
Type Description
System.Data.Common.DbParameterCollection
Overrides
System.Data.Common.DbCommand.DbParameterCollection

DbTransaction

Declaration
protected override DbTransaction DbTransaction { get; set; }
Property Value
Type Description
System.Data.Common.DbTransaction
Overrides
System.Data.Common.DbCommand.DbTransaction

DesignTimeVisible

Declaration
public override bool DesignTimeVisible { get; set; }
Property Value
Type Description
System.Boolean
Overrides
System.Data.Common.DbCommand.DesignTimeVisible

LastInsertedId

Declaration
public long LastInsertedId { get; }
Property Value
Type Description
System.Int64

Parameters

Declaration
public MySqlParameterCollection Parameters { get; }
Property Value
Type Description
MySqlParameterCollection

Transaction

Declaration
public MySqlTransaction Transaction { get; set; }
Property Value
Type Description
MySqlTransaction

UpdatedRowSource

Declaration
public override UpdateRowSource UpdatedRowSource { get; set; }
Property Value
Type Description
System.Data.UpdateRowSource
Overrides
System.Data.Common.DbCommand.UpdatedRowSource

Methods

Cancel()

Declaration
public override void Cancel()
Overrides
System.Data.Common.DbCommand.Cancel()

CreateDbParameter()

Declaration
protected override DbParameter CreateDbParameter()
Returns
Type Description
System.Data.Common.DbParameter
Overrides
System.Data.Common.DbCommand.CreateDbParameter()

CreateParameter()

Declaration
public MySqlParameter CreateParameter()
Returns
Type Description
MySqlParameter

Dispose(Boolean)

Declaration
protected override void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing
Overrides
System.ComponentModel.Component.Dispose(System.Boolean)

ExecuteDbDataReader(CommandBehavior)

Declaration
protected override DbDataReader ExecuteDbDataReader(CommandBehavior behavior)
Parameters
Type Name Description
System.Data.CommandBehavior behavior
Returns
Type Description
System.Data.Common.DbDataReader
Overrides
System.Data.Common.DbCommand.ExecuteDbDataReader(System.Data.CommandBehavior)

ExecuteDbDataReaderAsync(CommandBehavior, CancellationToken)

Declaration
protected override Task<DbDataReader> ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Data.CommandBehavior behavior
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Data.Common.DbDataReader>
Overrides
System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(System.Data.CommandBehavior, System.Threading.CancellationToken)

ExecuteNonQuery()

Declaration
public override int ExecuteNonQuery()
Returns
Type Description
System.Int32
Overrides
System.Data.Common.DbCommand.ExecuteNonQuery()

ExecuteNonQueryAsync(CancellationToken)

Declaration
public override Task<int> ExecuteNonQueryAsync(CancellationToken cancellationToken)
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Int32>
Overrides
System.Data.Common.DbCommand.ExecuteNonQueryAsync(System.Threading.CancellationToken)

ExecuteReader()

Declaration
public MySqlDataReader ExecuteReader()
Returns
Type Description
MySqlDataReader

ExecuteReader(CommandBehavior)

Declaration
public MySqlDataReader ExecuteReader(CommandBehavior commandBehavior)
Parameters
Type Name Description
System.Data.CommandBehavior commandBehavior
Returns
Type Description
MySqlDataReader

ExecuteScalar()

Declaration
public override object ExecuteScalar()
Returns
Type Description
System.Object
Overrides
System.Data.Common.DbCommand.ExecuteScalar()

ExecuteScalarAsync(CancellationToken)

Declaration
public override Task<object> ExecuteScalarAsync(CancellationToken cancellationToken)
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Object>
Overrides
System.Data.Common.DbCommand.ExecuteScalarAsync(System.Threading.CancellationToken)

Prepare()

Declaration
public override void Prepare()
Overrides
System.Data.Common.DbCommand.Prepare()

Implements

System.ComponentModel.IComponent
System.Data.IDbCommand
System.IDisposable

Extension Methods