C# Class MySql.Data.MySqlClient.MySqlCommand

Inheritance: ICloneable, IDisposable
Show file Open project: elevate/mysqlconnector-.net Class Usage Examples

Private Properties

Property Type Description
AddToBatch void
AsyncExecuteWrapper object
CheckState void
ClearCommandTimer void
Close void
EstimatedSize long
GetCommandTextForBatching string
HandleCommandBehaviors void
ICloneable object
Prepare void
ResetReader void
ResetSqlSelectLimit void
TrimSemicolons string

Public Methods

Method Description
BeginExecuteNonQuery ( ) : IAsyncResult

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.

BeginExecuteNonQuery ( AsyncCallback callback, object stateObject ) : IAsyncResult

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.

BeginExecuteReader ( ) : IAsyncResult

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.

BeginExecuteReader ( CommandBehavior behavior ) : IAsyncResult

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand using one of the CommandBehavior values.

Cancel ( ) : void

Attempts to cancel the execution of a currently active command

Cancelling a currently active query only works with MySQL versions 5.0.0 and higher.

Clone ( ) : MySqlCommand

Creates a clone of this MySqlCommand object. CommandText, Connection, and Transaction properties are included as well as the entire parameter list.

CreateParameter ( ) : MySqlParameter

Creates a new instance of a MySqlParameter object.

This method is a strongly-typed version of IDbCommand.CreateParameter.

EndExecuteNonQuery ( IAsyncResult asyncResult ) : int

Finishes asynchronous execution of a SQL statement.

EndExecuteReader ( IAsyncResult result ) : MySqlDataReader

Finishes asynchronous execution of a SQL statement, returning the requested MySqlDataReader.

ExecuteNonQuery ( ) : int
ExecuteReader ( ) : MySqlDataReader
ExecuteReader ( CommandBehavior behavior ) : MySqlDataReader
ExecuteScalar ( ) : object
MySqlCommand ( ) : System
MySqlCommand ( string cmdText ) : System
MySqlCommand ( string cmdText, MySqlConnection connection ) : System
MySqlCommand ( string cmdText, MySqlConnection connection, MySqlTransaction transaction ) : System
Prepare ( ) : void

Protected Methods

Method Description
CreateDbParameter ( ) : DbParameter
Dispose ( bool disposing ) : void
ExecuteDbDataReader ( CommandBehavior behavior ) : DbDataReader

Private Methods

Method Description
AddToBatch ( MySqlCommand command ) : void
AsyncExecuteWrapper ( int type, CommandBehavior behavior ) : object
CheckState ( ) : void

Check the connection to make sure - it is open - it is not currently being used by a reader - and we have the right version of MySQL for the requested command type

ClearCommandTimer ( ) : void
Close ( MySqlDataReader reader ) : void
EstimatedSize ( ) : long
GetCommandTextForBatching ( ) : string
HandleCommandBehaviors ( CommandBehavior behavior ) : void
ICloneable ( ) : object
Prepare ( int cursorPageSize ) : void
ResetReader ( ) : void

Reset reader to null, to avoid "There is already an open data reader" on the next ExecuteReader(). Used in error handling scenarios.

ResetSqlSelectLimit ( ) : void

Reset SQL_SELECT_LIMIT that could have been modified by CommandBehavior.

TrimSemicolons ( string sql ) : string

Method Details

BeginExecuteNonQuery() public method

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.
public BeginExecuteNonQuery ( ) : IAsyncResult
return IAsyncResult

BeginExecuteNonQuery() public method

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.
public BeginExecuteNonQuery ( AsyncCallback callback, object stateObject ) : IAsyncResult
callback AsyncCallback /// An delegate that is invoked when the command's /// execution has completed. Pass a null reference (Nothing in Visual Basic) /// to indicate that no callback is required.
stateObject object A user-defined state object that is passed to the /// callback procedure. Retrieve this object from within the callback procedure /// using the property.
return IAsyncResult

BeginExecuteReader() public method

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 BeginExecuteReader ( ) : IAsyncResult
return IAsyncResult

BeginExecuteReader() public method

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand using one of the CommandBehavior values.
public BeginExecuteReader ( CommandBehavior behavior ) : IAsyncResult
behavior CommandBehavior One of the values, indicating /// options for statement execution and data retrieval.
return IAsyncResult

Cancel() public method

Attempts to cancel the execution of a currently active command
Cancelling a currently active query only works with MySQL versions 5.0.0 and higher.
public Cancel ( ) : void
return void

Clone() public method

Creates a clone of this MySqlCommand object. CommandText, Connection, and Transaction properties are included as well as the entire parameter list.
public Clone ( ) : MySqlCommand
return MySqlCommand

CreateDbParameter() protected method

protected CreateDbParameter ( ) : DbParameter
return DbParameter

CreateParameter() public method

Creates a new instance of a MySqlParameter object.
This method is a strongly-typed version of IDbCommand.CreateParameter.
public CreateParameter ( ) : MySqlParameter
return MySqlParameter

Dispose() protected method

protected Dispose ( bool disposing ) : void
disposing bool
return void

EndExecuteNonQuery() public method

Finishes asynchronous execution of a SQL statement.
public EndExecuteNonQuery ( IAsyncResult asyncResult ) : int
asyncResult IAsyncResult The returned by the call /// to .
return int

EndExecuteReader() public method

Finishes asynchronous execution of a SQL statement, returning the requested MySqlDataReader.
public EndExecuteReader ( IAsyncResult result ) : MySqlDataReader
result IAsyncResult The returned by the call to /// .
return MySqlDataReader

ExecuteDbDataReader() protected method

protected ExecuteDbDataReader ( CommandBehavior behavior ) : DbDataReader
behavior CommandBehavior
return DbDataReader

ExecuteNonQuery() public method

public ExecuteNonQuery ( ) : int
return int

ExecuteReader() public method

public ExecuteReader ( ) : MySqlDataReader
return MySqlDataReader

ExecuteReader() public method

public ExecuteReader ( CommandBehavior behavior ) : MySqlDataReader
behavior CommandBehavior
return MySqlDataReader

ExecuteScalar() public method

public ExecuteScalar ( ) : object
return object

MySqlCommand() public method

public MySqlCommand ( ) : System
return System

MySqlCommand() public method

public MySqlCommand ( string cmdText ) : System
cmdText string
return System

MySqlCommand() public method

public MySqlCommand ( string cmdText, MySqlConnection connection ) : System
cmdText string
connection MySqlConnection
return System

MySqlCommand() public method

public MySqlCommand ( string cmdText, MySqlConnection connection, MySqlTransaction transaction ) : System
cmdText string
connection MySqlConnection
transaction MySqlTransaction
return System

Prepare() public method

public Prepare ( ) : void
return void