Class MySqlHelper
Helper class that makes it easier to work with the provider.
Inheritance
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. |
value | The string to modidify. |
Returns
Type | Description |
---|---|
System. |
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. |
value | The string to escape. |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Settings to be used for the connection |
System. |
commandText | Command to execute |
My |
parms | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | The settings to be used for the connection. |
System. |
commandText | The command to execute. |
My |
parms | The parameters to use for the command. |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | The settings to be used for the connection. |
System. |
commandText | The command to execute. |
System. |
cancellationToken | The cancellation token. |
My |
parms | The parameters to use for the command. |
Returns
Type | Description |
---|---|
System. |
The DataRow containing the first row of the resultset. |
ExecuteDataset(MySqlConnection, String)
Executes a single SQL command and returns the resultset in a System.
The state of the My
Declaration
public static DataSet ExecuteDataset(MySqlConnection connection, string commandText)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | My |
System. |
commandText | Command to execute |
Returns
Type | Description |
---|---|
System. |
System. |
ExecuteDataset(MySqlConnection, String, MySqlParameter[])
Executes a single SQL command and returns the resultset in a System.
The state of the My
Declaration
public static DataSet ExecuteDataset(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | My |
System. |
commandText | Command to execute |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
System. |
ExecuteDataset(String, String)
Executes a single SQL command and returns the resultset in a System.
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. |
connectionString | Settings to be used for the connection |
System. |
commandText | Command to execute |
Returns
Type | Description |
---|---|
System. |
System. |
ExecuteDataset(String, String, MySqlParameter[])
Executes a single SQL command and returns the resultset in a System.
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. |
connectionString | Settings to be used for the connection |
System. |
commandText | Command to execute |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
System. |
ExecuteDatasetAsync(MySqlConnection, String)
Async version of ExecuteDataset
Declaration
public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | My |
System. |
commandText | Command to execute |
Returns
Type | Description |
---|---|
System. |
System. |
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 |
---|---|---|
My |
connection | My |
System. |
commandText | Command to execute |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
System. |
ExecuteDatasetAsync(MySqlConnection, String, CancellationToken)
Declaration
public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |
ExecuteDatasetAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
Declaration
public static Task<DataSet> ExecuteDatasetAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
ExecuteDatasetAsync(String, String)
Async version of ExecuteDataset
Declaration
public static Task<DataSet> ExecuteDatasetAsync(string connectionString, string commandText)
Parameters
Type | Name | Description |
---|---|---|
System. |
connectionString | Settings to be used for the connection |
System. |
commandText | Command to execute |
Returns
Type | Description |
---|---|
System. |
System. |
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. |
connectionString | Settings to be used for the connection |
System. |
commandText | Command to execute |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
System. |
ExecuteDatasetAsync(String, String, CancellationToken)
Declaration
public static Task<DataSet> ExecuteDatasetAsync(string connectionString, string commandText, CancellationToken cancellationToken)
Parameters
Type | Name | Description |
---|---|---|
System. |
connectionString | |
System. |
commandText | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
ExecuteNonQuery(MySqlConnection, String, MySqlParameter[])
Executes a single command against a MySQL database. The My
Declaration
public static int ExecuteNonQuery(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | The My |
System. |
commandText | The SQL command to be executed. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Connection |
System. |
commandText | The SQL command to be executed. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
The number of affected records. |
Remarks
A new My
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 |
---|---|---|
My |
connection | My |
System. |
commandText | The SQL command to be executed. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Connection |
System. |
commandText | The SQL command to be executed. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Connection |
System. |
commandText | The SQL command to be executed. |
System. |
cancellationToken | The cancellation token. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
My |
connection | My |
System. |
commandText | Command text to use |
Returns
Type | Description |
---|---|
My |
My |
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 |
---|---|---|
My |
connection | Connection to use for the command |
System. |
commandText | Command text to use |
My |
commandParameters | Array of My |
Returns
Type | Description |
---|---|
My |
My |
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. |
connectionString | Settings to use for this command |
System. |
commandText | Command text to use |
Returns
Type | Description |
---|---|
My |
My |
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. |
connectionString | Settings to use for this command |
System. |
commandText | Command text to use |
My |
commandParameters | Array of My |
Returns
Type | Description |
---|---|
My |
My |
ExecuteReaderAsync(MySqlConnection, String)
Async version of ExecuteReader
Declaration
public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | My |
System. |
commandText | Command text to use |
Returns
Type | Description |
---|---|
System. |
My |
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 |
---|---|---|
My |
connection | Connection to use for the command. |
System. |
commandText | Command text to use. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
My |
ExecuteReaderAsync(MySqlConnection, String, CancellationToken)
Declaration
public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |
ExecuteReaderAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
Declaration
public static Task<MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
ExecuteReaderAsync(String, String)
Async version of ExecuteReader
Declaration
public static Task<MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText)
Parameters
Type | Name | Description |
---|---|---|
System. |
connectionString | Settings to use for this command |
System. |
commandText | Command text to use |
Returns
Type | Description |
---|---|
System. |
My |
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. |
connectionString | Settings to use for this command. |
System. |
commandText | Command text to use. |
My |
commandParameters | An array of My |
Returns
Type | Description |
---|---|
System. |
My |
ExecuteReaderAsync(String, String, CancellationToken)
Declaration
public static Task<MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText, CancellationToken cancellationToken)
Parameters
Type | Name | Description |
---|---|---|
System. |
connectionString | |
System. |
commandText | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
ExecuteScalar(MySqlConnection, String)
Execute a single command against a MySQL database.
Declaration
public static object ExecuteScalar(MySqlConnection connection, string commandText)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | My |
System. |
commandText | Command text to use for the command |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
My |
connection | My |
System. |
commandText | Command text to use for the command |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Settings to use for the update |
System. |
commandText | Command text to use for the update |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Settings to use for the command |
System. |
commandText | Command text to use for the command |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
My |
connection | My |
System. |
commandText | Command text to use for the command |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
My |
connection | My |
System. |
commandText | Command text to use for the command |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
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 |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |
ExecuteScalarAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
Declaration
public static Task<object> ExecuteScalarAsync(MySqlConnection connection, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)
Parameters
Type | Name | Description |
---|---|---|
My |
connection | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
ExecuteScalarAsync(String, String)
Async version of ExecuteScalar
Declaration
public static Task<object> ExecuteScalarAsync(string connectionString, string commandText)
Parameters
Type | Name | Description |
---|---|---|
System. |
connectionString | Settings to use for the update |
System. |
commandText | Command text to use for the update |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | Settings to use for the command |
System. |
commandText | Command text to use for the command |
My |
commandParameters | Parameters to use for the command |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | |
System. |
commandText | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | |
System. |
commandText | |
System. |
cancellationToken | |
My |
commandParameters |
Returns
Type | Description |
---|---|
System. |
UpdateDataSet(String, String, DataSet, String)
Updates the given table with data from the given System.
Declaration
public static void UpdateDataSet(string connectionString, string commandText, DataSet ds, string tablename)
Parameters
Type | Name | Description |
---|---|---|
System. |
connectionString | Settings to use for the update |
System. |
commandText | Command text to use for the update |
System. |
ds | System. |
System. |
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. |
connectionString | Settings to use for the update |
System. |
commandText | Command text to use for the update |
System. |
ds | System. |
System. |
tablename | Tablename in the dataset to update |
Returns
Type | Description |
---|---|
System. |
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. |
connectionString | |
System. |
commandText | |
System. |
ds | |
System. |
tablename | |
System. |
cancellationToken |
Returns
Type | Description |
---|---|
System. |