MySqlCommand Members

MySQL Connector.Net

previous page next page
Collapse image Expand Image Copy image CopyHover image

The MySqlCommand type exposes the following members.

Constructors

  Name Description
Public method MySqlCommand()()()()
Initializes a new instance of the MySqlCommand class.
Public method MySqlCommand(String)
Initializes a new instance of the MySqlCommand class with the text of the query.
Public method MySqlCommand(String, MySqlConnection)
Initializes a new instance of the MySqlCommand class with the text of the query and a MySqlConnection.
Public method MySqlCommand(String, MySqlConnection, MySqlTransaction)
Initializes a new instance of the MySqlCommand class with the text of the query, a MySqlConnection, and the MySqlTransaction.

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 DbCommand..::..Cancel()()()().)
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 DbCommand..::..CreateDbParameter()()()().)
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)
Releases the unmanaged resources used by the Component and optionally releases the managed resources.
(Inherited from Component.)
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 DbCommand..::..ExecuteDbDataReader(CommandBehavior).)
Public method ExecuteNonQuery
Executes a SQL statement against the connection and returns the number of rows affected.
(Overrides DbCommand..::..ExecuteNonQuery()()()().)
Public method ExecuteNonQueryAsync
Async version of ExecuteNonQuery
Public method 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()()()()
Async version of ExecuteReader
Public method ExecuteReaderAsync(CommandBehavior)
Async version of ExecuteReader
Public method 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 DbCommand..::..ExecuteScalar()()()().)
Public method ExecuteScalarAsync
Async version of ExecuteScalar
Protected method Finalize
Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.
(Inherited from Component.)
Public method GetHashCode
Serves as a hash function for a particular type.
(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 Prepare
Creates a prepared version of the command on an instance of MySQL Server.
(Overrides DbCommand..::..Prepare()()()().)
Public method ToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)

Properties

  Name Description
Public property CacheAge
Protected property CanRaiseEvents
Gets a value indicating whether the component can raise an event.
(Inherited from Component.)
Public property CommandText
Gets or sets the SQL statement to execute at the data source.
(Overrides DbCommand..::..CommandText.)
Public property CommandTimeout
Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
(Overrides DbCommand..::..CommandTimeout.)
Public property CommandType
Gets or sets a value indicating how the CommandText property is to be interpreted.
(Overrides DbCommand..::..CommandType.)
Public property Connection
Gets or sets the MySqlConnection used by this instance of the MySqlCommand.
Public property Container
Gets the IContainer that contains the Component.
(Inherited from Component.)
Protected property DbConnection (Overrides DbCommand..::..DbConnection.)
Protected property DbParameterCollection (Overrides DbCommand..::..DbParameterCollection.)
Protected property DbTransaction (Overrides DbCommand..::..DbTransaction.)
Protected property DesignMode
Gets a value that indicates whether the Component is currently in design mode.
(Inherited from Component.)
Public property DesignTimeVisible
Gets or sets a value indicating whether the command object should be visible in a Windows Form Designer control.
(Overrides DbCommand..::..DesignTimeVisible.)
Public property EnableCaching
Protected property Events
Gets the list of event handlers that are attached to this Component.
(Inherited from Component.)
Public property IsPrepared
Public property LastInsertedId
Public property Parameters
Get the MySqlParameterCollection
Public property Site
Gets or sets the ISite of the Component.
(Inherited from Component.)
Public property Transaction
Gets or sets the MySqlTransaction within which the MySqlCommand executes.
Public property UpdatedRowSource
Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.
(Overrides DbCommand..::..UpdatedRowSource.)

Events

  Name Description
Public event Disposed
Occurs when the component is disposed by a call to the Dispose()()()() method.
(Inherited from Component.)

See Also

previous page start next page