MySqlHelper Class

MySQL Connector/Net

MySqlHelper Class
Helper class that makes it easier to work with the provider.
Inheritance Hierarchy
SystemObject  MySql.Data.MySqlClientMySqlHelper

Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
public sealed class MySqlHelper
Public NotInheritable Class MySqlHelper
public ref class MySqlHelper sealed
[<SealedAttribute>]
type MySqlHelper =  class end

The MySqlHelper type exposes the following members.

Methods
  NameDescription
Public methodStatic memberDoubleQuoteString
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodStatic memberEscapeString
Escapes the string.
Public methodStatic memberExecuteDataRow
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 methodStatic memberExecuteDataRowAsync(String, String, MySqlParameter)
Async version of ExecuteDataRow
Public methodStatic memberExecuteDataRowAsync(String, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteDataset(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 methodStatic memberExecuteDataset(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 methodStatic memberExecuteDataset(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 methodStatic memberExecuteDataset(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 methodStatic memberExecuteDatasetAsync(String, String)
Async version of ExecuteDataset
Public methodStatic memberExecuteDatasetAsync(MySqlConnection, String)
Async version of ExecuteDataset
Public methodStatic memberExecuteDatasetAsync(String, String, MySqlParameter)
Async version of ExecuteDataset
Public methodStatic memberExecuteDatasetAsync(String, String, CancellationToken)
Public methodStatic memberExecuteDatasetAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteDataset
Public methodStatic memberExecuteDatasetAsync(MySqlConnection, String, CancellationToken)
Public methodStatic memberExecuteDatasetAsync(String, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteDatasetAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteNonQuery(String, String, MySqlParameter)
Executes a single command against a MySQL database. A new MySqlConnection is created using the ConnectionString given.
Public methodStatic memberExecuteNonQuery(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 methodStatic memberExecuteNonQueryAsync(String, String, MySqlParameter)
Async version of ExecuteNonQuery
Public methodStatic memberExecuteNonQueryAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteNonQuery
Public methodStatic memberExecuteNonQueryAsync(String, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteNonQueryAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteReader(String, String)
Executes a single command against a MySQL database.
Public methodStatic memberExecuteReader(MySqlConnection, String)
Executes a single command against a MySQL database.
Public methodStatic memberExecuteReader(String, String, MySqlParameter)
Executes a single command against a MySQL database.
Public methodStatic memberExecuteReader(MySqlConnection, String, MySqlParameter)
Executes a single command against a MySQL database.
Public methodStatic memberExecuteReaderAsync(String, String)
Async version of ExecuteReader
Public methodStatic memberExecuteReaderAsync(MySqlConnection, String)
Async version of ExecuteReader
Public methodStatic memberExecuteReaderAsync(String, String, MySqlParameter)
Async version of ExecuteReader
Public methodStatic memberExecuteReaderAsync(String, String, CancellationToken)
Public methodStatic memberExecuteReaderAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteReader
Public methodStatic memberExecuteReaderAsync(MySqlConnection, String, CancellationToken)
Public methodStatic memberExecuteReaderAsync(String, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteReaderAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteScalar(String, String)
Execute a single command against a MySQL database.
Public methodStatic memberExecuteScalar(MySqlConnection, String)
Execute a single command against a MySQL database.
Public methodStatic memberExecuteScalar(String, String, MySqlParameter)
Execute a single command against a MySQL database.
Public methodStatic memberExecuteScalar(MySqlConnection, String, MySqlParameter)
Execute a single command against a MySQL database.
Public methodStatic memberExecuteScalarAsync(String, String)
Async version of ExecuteScalar
Public methodStatic memberExecuteScalarAsync(MySqlConnection, String)
Async version of ExecuteScalar
Public methodStatic memberExecuteScalarAsync(String, String, MySqlParameter)
Async version of ExecuteScalar
Public methodStatic memberExecuteScalarAsync(String, String, CancellationToken)
Public methodStatic memberExecuteScalarAsync(MySqlConnection, String, MySqlParameter)
Async version of ExecuteScalar
Public methodStatic memberExecuteScalarAsync(MySqlConnection, String, CancellationToken)
Public methodStatic memberExecuteScalarAsync(String, String, CancellationToken, MySqlParameter)
Public methodStatic memberExecuteScalarAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodStatic memberUpdateDataSet
Updates the given table with data from the given DataSet
Public methodStatic memberUpdateDataSetAsync(String, String, DataSet, String)
Async version of UpdateDataset
Public methodStatic memberUpdateDataSetAsync(String, String, DataSet, String, CancellationToken)
Top
See Also