MySqlHelper Methods

MySQL Connector/Net

previous page next page
MySqlHelper Methods

The MySqlHelper type exposes the following members.

Methods
  Name Description
Public method Static member DoubleQuoteString
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public method Static member EscapeString
Escapes the string.
Public method Static member ExecuteDataRow
Executes a single SQL command and returns the first row of the resultset. A new MySqlConnection object is created, opened, and closed during this method.
Public method Static member ExecuteDataRowAsync(String, String, MySqlParameter)
Async version of ExecuteDataRow
Public method Static member ExecuteDataRowAsync(String, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteDataset(String, String)
Executes a single SQL command and returns the resultset in a DataSet. A new MySqlConnection object is created, opened, and closed during this method.
Public method Static member ExecuteDataset(MySqlConnection, String)
Executes a single SQL command and returns the resultset in a DataSet. The state of the MySqlConnection object remains unchanged after execution of this method.
Public method Static member ExecuteDataset(String, String, MySqlParameter)
Executes a single SQL command and returns the resultset in a DataSet. A new MySqlConnection object is created, opened, and closed during this method.
Public method Static member ExecuteDataset(MySqlConnection, String, MySqlParameter)
Executes a single SQL command and returns the resultset in a DataSet. The state of the MySqlConnection object remains unchanged after execution of this method.
Public method Static member ExecuteDatasetAsync(String, String)
Async version of ExecuteDataset
Public method Static member ExecuteDatasetAsync(MySqlConnection, String)
Async version of ExecuteDataset
Public method Static member ExecuteDatasetAsync(String, String, MySqlParameter)
Async version of ExecuteDataset
Public method Static member ExecuteDatasetAsync(String, String, CancellationToken)
Public method Static member ExecuteDatasetAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteDataset
Public method Static member ExecuteDatasetAsync(MySqlConnection, String, CancellationToken)
Public method Static member ExecuteDatasetAsync(String, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteDatasetAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteNonQuery(String, String, MySqlParameter)
Executes a single command against a MySQL database. A new MySqlConnection is created using the ConnectionString given.
Public method Static member ExecuteNonQuery(MySqlConnection, String, MySqlParameter)
Executes a single command against a MySQL database. The MySqlConnection is assumed to be open when the method is called and remains open after the method completes.
Public method Static member ExecuteNonQueryAsync(String, String, MySqlParameter)
Async version of ExecuteNonQuery
Public method Static member ExecuteNonQueryAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteNonQuery
Public method Static member ExecuteNonQueryAsync(String, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteNonQueryAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteReader(String, String)
Executes a single command against a MySQL database.
Public method Static member ExecuteReader(MySqlConnection, String)
Executes a single command against a MySQL database.
Public method Static member ExecuteReader(String, String, MySqlParameter)
Executes a single command against a MySQL database.
Public method Static member ExecuteReader(MySqlConnection, String, MySqlParameter)
Executes a single command against a MySQL database.
Public method Static member ExecuteReaderAsync(String, String)
Async version of ExecuteReader
Public method Static member ExecuteReaderAsync(MySqlConnection, String)
Async version of ExecuteReader
Public method Static member ExecuteReaderAsync(String, String, MySqlParameter)
Async version of ExecuteReader
Public method Static member ExecuteReaderAsync(String, String, CancellationToken)
Public method Static member ExecuteReaderAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteReader
Public method Static member ExecuteReaderAsync(MySqlConnection, String, CancellationToken)
Public method Static member ExecuteReaderAsync(String, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteReaderAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteScalar(String, String)
Execute a single command against a MySQL database.
Public method Static member ExecuteScalar(MySqlConnection, String)
Execute a single command against a MySQL database.
Public method Static member ExecuteScalar(String, String, MySqlParameter)
Execute a single command against a MySQL database.
Public method Static member ExecuteScalar(MySqlConnection, String, MySqlParameter)
Execute a single command against a MySQL database.
Public method Static member ExecuteScalarAsync(String, String)
Async version of ExecuteScalar
Public method Static member ExecuteScalarAsync(MySqlConnection, String)
Async version of ExecuteScalar
Public method Static member ExecuteScalarAsync(String, String, MySqlParameter)
Async version of ExecuteScalar
Public method Static member ExecuteScalarAsync(String, String, CancellationToken)
Public method Static member ExecuteScalarAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteScalar
Public method Static member ExecuteScalarAsync(MySqlConnection, String, CancellationToken)
Public method Static member ExecuteScalarAsync(String, String, CancellationToken, MySqlParameter)
Public method Static member ExecuteScalarAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected method MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object.)
Public method Static member UpdateDataSet
Updates the given table with data from the given DataSet
Public method Static member UpdateDataSetAsync(String, String, DataSet, String)
Async version of UpdateDataset
Public method Static member UpdateDataSetAsync(String, String, DataSet, String, CancellationToken)
Top
See Also
previous page start next page