MySqlCommand Methods

MySQL Connector/Net

MySqlCommand Methods

The MySqlCommand type exposes the following members.

Methods
  Name Description
Public method BeginExecuteNonQuery
Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.
Public method BeginExecuteNonQuery(AsyncCallback, Object)
Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.
Public method BeginExecuteReader
Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand, and retrieves one or more result sets from the server.
Public method BeginExecuteReader(CommandBehavior)
Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand using one of the CommandBehavior values.
Public method Cancel
Attempts to cancel the execution of a currently active command
(Overrides DbCommandCancel.)
Public method Clone
Creates a clone of this MySqlCommand object. CommandText, Connection, and Transaction properties are included as well as the entire parameter list.
Protected method CreateDbParameter (Overrides DbCommandCreateDbParameter.)
Public method CreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
Public method CreateParameter
Creates a new instance of a MySqlParameter object.
Public method Dispose
Protected method Dispose(Boolean) (Overrides ComponentDispose(Boolean).)
Public method EndExecuteNonQuery
Finishes asynchronous execution of a SQL statement.
Public method EndExecuteReader
Finishes asynchronous execution of a SQL statement, returning the requested MySqlDataReader.
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected method ExecuteDbDataReader (Overrides DbCommandExecuteDbDataReader(CommandBehavior).)
Protected method ExecuteDbDataReaderAsync (Inherited from DbCommand.)
Public method Code example ExecuteNonQuery
Executes a SQL statement against the connection and returns the number of rows affected.
(Overrides DbCommandExecuteNonQuery.)
Public method ExecuteNonQueryAsync (Inherited from DbCommand.)
Public method ExecuteNonQueryAsync(CancellationToken) (Inherited from DbCommand.)
Public method Code example ExecuteReader
Sends the CommandText to the Connection and builds a MySqlDataReader.
Public method ExecuteReader(CommandBehavior)
Sends the CommandText to the Connection, and builds a MySqlDataReader using one of the CommandBehavior values.
Public method ExecuteReaderAsync (Inherited from DbCommand.)
Public method ExecuteReaderAsync(CancellationToken) (Inherited from DbCommand.)
Public method ExecuteReaderAsync(CommandBehavior) (Inherited from DbCommand.)
Public method ExecuteReaderAsync(CommandBehavior, CancellationToken) (Inherited from DbCommand.)
Public method Code example ExecuteScalar
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
(Overrides DbCommandExecuteScalar.)
Public method ExecuteScalarAsync (Inherited from DbCommand.)
Public method ExecuteScalarAsync(CancellationToken) (Inherited from DbCommand.)
Protected method Finalize (Overrides ComponentFinalize.)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public method GetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method GetService
Returns an object that represents a service provided by the Component or by its Container.
(Inherited from Component.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method InitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected method MemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Public method Code example Prepare
Creates a prepared version of the command on an instance of MySQL Server.
(Overrides DbCommandPrepare.)
Public method ToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)
Top
See Also