Class MySqlHelper

Helper class that makes it easier to work with the provider.

Inheritance

System.Object

MySqlHelper

Namespace: MySql.Data.MySqlClient

Assembly: MySql.Data.dll

Version: 9.3.0

Syntax

public sealed class MySqlHelper

Methods

DoubleQuoteString(String)

Replaces quotes with double quotes.

Declaration

public static string DoubleQuoteString(string value)

Parameters

Type	Name	Description
System.String	value	The string to modidify.

Returns

Type	Description
System.String	A string containing double quotes instead of single quotes.

EscapeString(String)

Escapes the string.

Declaration

public static string EscapeString(string value)

Parameters

Type	Name	Description
System.String	value	The string to escape.

Returns

Type	Description
System.String	The string with all quotes escaped.

ExecuteDataRow(String, String, MySqlParameter[])

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.

Declaration

public static DataRow ExecuteDataRow(string connectionString, string commandText, params MySqlParameter[] parms)

Parameters

Type	Name	Description
System.String	connectionString	Settings to be used for the connection
System.String	commandText	Command to execute
MySqlParameter[]	parms	Parameters to use for the command

Returns

Type	Description
System.Data.DataRow	DataRow containing the first row of the resultset

ExecuteDataRowAsync(String, String, MySqlParameter[])

Asynchronous version of ExecuteDataRow.

Declaration

public static Task<DataRow> ExecuteDataRowAsync(string connectionString, string commandText, params MySqlParameter[] parms)

Parameters

Type	Name	Description
System.String	connectionString	The settings to be used for the connection.
System.String	commandText	The command to execute.
MySqlParameter[]	parms	The parameters to use for the command.

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataRow>	The DataRow containing the first row of the resultset.

ExecuteDataRowAsync(String, String, CancellationToken, MySqlParameter[])

Asynchronous version of ExecuteDataRow.

Declaration

public static Task<DataRow> ExecuteDataRowAsync(string connectionString, string commandText, CancellationToken cancellationToken, params MySqlParameter[] parms)

Parameters

Type	Name	Description
System.String	connectionString	The settings to be used for the connection.
System.String	commandText	The command to execute.
System.Threading.CancellationToken	cancellationToken	The cancellation token.
MySqlParameter[]	parms	The parameters to use for the command.

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataRow>	The DataRow containing the first row of the resultset.

ExecuteDataset(MySqlConnection, String)

Executes a single SQL command and returns the resultset in a System.Data.DataSet.
The state of the MySqlConnection object remains unchanged after execution of this method.

Declaration

public static DataSet ExecuteDataset(MySqlConnection connection, string commandText)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command to execute

Returns

Type	Description
System.Data.DataSet	System.Data.DataSet containing the resultset

ExecuteDataset(MySqlConnection, String, MySqlParameter[])

Executes a single SQL command and returns the resultset in a System.Data.DataSet.
The state of the MySqlConnection object remains unchanged after execution of this method.

Declaration

public static DataSet ExecuteDataset(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command to execute
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Data.DataSet	System.Data.DataSet containing the resultset

ExecuteDataset(String, String)

Executes a single SQL command and returns the resultset in a System.Data.DataSet.
A new MySqlConnection object is created, opened, and closed during this method.

Declaration

public static DataSet ExecuteDataset(string connectionString, string commandText)

Parameters

Type	Name	Description
System.String	connectionString	Settings to be used for the connection
System.String	commandText	Command to execute

Returns

Type	Description
System.Data.DataSet	System.Data.DataSet containing the resultset

ExecuteDataset(String, String, MySqlParameter[])

Executes a single SQL command and returns the resultset in a System.Data.DataSet.
A new MySqlConnection object is created, opened, and closed during this method.

Declaration

public static DataSet ExecuteDataset(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	Settings to be used for the connection
System.String	commandText	Command to execute
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Data.DataSet	System.Data.DataSet containing the resultset

ExecuteDatasetAsync(MySqlConnection, String)

Async version of ExecuteDataset

Declaration

public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command to execute

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>	System.Data.DataSet containing the resultset

ExecuteDatasetAsync(MySqlConnection, String, MySqlParameter[])

Async version of ExecuteDataset

Declaration

public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command to execute
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>	System.Data.DataSet containing the resultset

ExecuteDatasetAsync(MySqlConnection, String, CancellationToken)

Declaration

public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDatasetAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDatasetAsync(String, String)

Async version of ExecuteDataset

Declaration

public static Task<DataSet> ExecuteDatasetAsync(string connectionString, string commandText)

Parameters

Type	Name	Description
System.String	connectionString	Settings to be used for the connection
System.String	commandText	Command to execute

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>	System.Data.DataSet containing the resultset

ExecuteDatasetAsync(String, String, MySqlParameter[])

Async version of ExecuteDataset

Declaration

public static Task<DataSet> ExecuteDatasetAsync(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	Settings to be used for the connection
System.String	commandText	Command to execute
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>	System.Data.DataSet containing the resultset

ExecuteDatasetAsync(String, String, CancellationToken)

Declaration

public static Task<DataSet> ExecuteDatasetAsync(string connectionString, string commandText, CancellationToken cancellationToken)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDatasetAsync(String, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<DataSet> ExecuteDatasetAsync(string connectionString, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

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.

Declaration

public static int ExecuteNonQuery(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	The MySqlConnection object to use
System.String	commandText	The SQL command to be executed.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Int32	The number of affected records.

ExecuteNonQuery(String, String, MySqlParameter[])

Executes a single command against a MySQL database.

Declaration

public static int ExecuteNonQuery(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	ConnectionString to use.
System.String	commandText	The SQL command to be executed.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Int32	The number of affected records.

Remarks

A new MySqlConnection is created using the ConnectionString given.

ExecuteNonQueryAsync(MySqlConnection, String, MySqlParameter[])

Async version of ExecuteNonQuery

Declaration

public static Task<int> ExecuteNonQueryAsync(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use.
System.String	commandText	The SQL command to be executed.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>	Rows affected.

ExecuteNonQueryAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<int> ExecuteNonQueryAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(String, String, MySqlParameter[])

Asynchronous version of the ExecuteNonQuery method.

Declaration

public static Task<int> ExecuteNonQueryAsync(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	ConnectionString to use.
System.String	commandText	The SQL command to be executed.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>	The number of rows affected.

ExecuteNonQueryAsync(String, String, CancellationToken, MySqlParameter[])

Asynchronous version of the ExecuteNonQuery method.

Declaration

public static Task<int> ExecuteNonQueryAsync(string connectionString, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	ConnectionString to use.
System.String	commandText	The SQL command to be executed.
System.Threading.CancellationToken	cancellationToken	The cancellation token.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>	The number of rows affected.

ExecuteReader(MySqlConnection, String)

Executes a single command against a MySQL database.

Declaration

public static MySqlDataReader ExecuteReader(MySqlConnection connection, string commandText)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use for the command
System.String	commandText	Command text to use

Returns

Type	Description
MySqlDataReader	MySqlDataReader object ready to read the results of the command

ExecuteReader(MySqlConnection, String, MySqlParameter[])

Executes a single command against a MySQL database.

Declaration

public static MySqlDataReader ExecuteReader(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	Connection to use for the command
System.String	commandText	Command text to use
MySqlParameter[]	commandParameters	Array of MySqlParameter objects to use with the command

Returns

Type	Description
MySqlDataReader	MySqlDataReader object ready to read the results of the command

ExecuteReader(String, String)

Executes a single command against a MySQL database.

Declaration

public static MySqlDataReader ExecuteReader(string connectionString, string commandText)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for this command
System.String	commandText	Command text to use

Returns

Type	Description
MySqlDataReader	MySqlDataReader object ready to read the results of the command

ExecuteReader(String, String, MySqlParameter[])

Executes a single command against a MySQL database.

Declaration

public static MySqlDataReader ExecuteReader(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for this command
System.String	commandText	Command text to use
MySqlParameter[]	commandParameters	Array of MySqlParameter objects to use with the command

Returns

Type	Description
MySqlDataReader	MySqlDataReader object ready to read the results of the command

ExecuteReaderAsync(MySqlConnection, String)

Async version of ExecuteReader

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use for the command
System.String	commandText	Command text to use

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>	MySqlDataReader object ready to read the results of the command

ExecuteReaderAsync(MySqlConnection, String, MySqlParameter[])

Async version of ExecuteReader

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	Connection to use for the command.
System.String	commandText	Command text to use.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>	MySqlDataReader object ready to read the results of the command.

ExecuteReaderAsync(MySqlConnection, String, CancellationToken)

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>

ExecuteReaderAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>

ExecuteReaderAsync(String, String)

Async version of ExecuteReader

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for this command
System.String	commandText	Command text to use

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>	MySqlDataReader object ready to read the results of the command

ExecuteReaderAsync(String, String, MySqlParameter[])

Async version of ExecuteReader

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for this command.
System.String	commandText	Command text to use.
MySqlParameter[]	commandParameters	An array of MySqlParameter objects to use with the command.

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>	MySqlDataReader object ready to read the results of the command.

ExecuteReaderAsync(String, String, CancellationToken)

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText, CancellationToken cancellationToken)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>

ExecuteReaderAsync(String, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<MySqlDataReader>

ExecuteScalar(MySqlConnection, String)

Execute a single command against a MySQL database.

Declaration

public static object ExecuteScalar(MySqlConnection connection, string commandText)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command text to use for the command

Returns

Type	Description
System.Object	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalar(MySqlConnection, String, MySqlParameter[])

Execute a single command against a MySQL database.

Declaration

public static object ExecuteScalar(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command text to use for the command
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Object	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalar(String, String)

Execute a single command against a MySQL database.

Declaration

public static object ExecuteScalar(string connectionString, string commandText)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for the update
System.String	commandText	Command text to use for the update

Returns

Type	Description
System.Object	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalar(String, String, MySqlParameter[])

Execute a single command against a MySQL database.

Declaration

public static object ExecuteScalar(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for the command
System.String	commandText	Command text to use for the command
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Object	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalarAsync(MySqlConnection, String)

Async version of ExecuteScalar

Declaration

public static Task<object> ExecuteScalarAsync(MySqlConnection connection, string commandText)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command text to use for the command

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalarAsync(MySqlConnection, String, MySqlParameter[])

Async version of ExecuteScalar

Declaration

public static Task<object> ExecuteScalarAsync(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection	MySqlConnection object to use
System.String	commandText	Command text to use for the command
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalarAsync(MySqlConnection, String, CancellationToken)

Declaration

public static Task<object> ExecuteScalarAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<object> ExecuteScalarAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
MySqlConnection	connection
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(String, String)

Async version of ExecuteScalar

Declaration

public static Task<object> ExecuteScalarAsync(string connectionString, string commandText)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for the update
System.String	commandText	Command text to use for the update

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalarAsync(String, String, MySqlParameter[])

Async version of ExecuteScalar

Declaration

public static Task<object> ExecuteScalarAsync(string connectionString, string commandText, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for the command
System.String	commandText	Command text to use for the command
MySqlParameter[]	commandParameters	Parameters to use for the command

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>	The first column of the first row in the result set, or a null reference if the result set is empty.

ExecuteScalarAsync(String, String, CancellationToken)

Declaration

public static Task<object> ExecuteScalarAsync(string connectionString, string commandText, CancellationToken cancellationToken)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(String, String, CancellationToken, MySqlParameter[])

Declaration

public static Task<object> ExecuteScalarAsync(string connectionString, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Threading.CancellationToken	cancellationToken
MySqlParameter[]	commandParameters

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

UpdateDataSet(String, String, DataSet, String)

Updates the given table with data from the given System.Data.DataSet

Declaration

public static void UpdateDataSet(string connectionString, string commandText, DataSet ds, string tablename)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for the update
System.String	commandText	Command text to use for the update
System.Data.DataSet	ds	System.Data.DataSet containing the new data to use in the update
System.String	tablename	Tablename in the dataset to update

UpdateDataSetAsync(String, String, DataSet, String)

Async version of UpdateDataset

Declaration

public static Task UpdateDataSetAsync(string connectionString, string commandText, DataSet ds, string tablename)

Parameters

Type	Name	Description
System.String	connectionString	Settings to use for the update
System.String	commandText	Command text to use for the update
System.Data.DataSet	ds	System.Data.DataSet containing the new data to use in the update
System.String	tablename	Tablename in the dataset to update

Returns

Type	Description
System.Threading.Tasks.Task

UpdateDataSetAsync(String, String, DataSet, String, CancellationToken)

Declaration

public static Task UpdateDataSetAsync(string connectionString, string commandText, DataSet ds, string tablename, CancellationToken cancellationToken)

Parameters

Type	Name	Description
System.String	connectionString
System.String	commandText
System.Data.DataSet	ds
System.String	tablename
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task