MySqlHelper Class

MySQL Connector/Net

previous page next page

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

C++

Copy

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

	Name	Description
	DoubleQuoteString
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	EscapeString	Escapes the string.
	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.
	ExecuteDataRowAsync(String, String, MySqlParameter)	Async version of ExecuteDataRow
	ExecuteDataRowAsync(String, String, CancellationToken, MySqlParameter)
	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.
	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.
	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.
	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.
	ExecuteDatasetAsync(String, String)	Async version of ExecuteDataset
	ExecuteDatasetAsync(MySqlConnection, String)	Async version of ExecuteDataset
	ExecuteDatasetAsync(String, String, MySqlParameter)	Async version of ExecuteDataset
	ExecuteDatasetAsync(String, String, CancellationToken)
	ExecuteDatasetAsync(MySqlConnection, String, MySqlParameter)	Async version of ExecuteDataset
	ExecuteDatasetAsync(MySqlConnection, String, CancellationToken)
	ExecuteDatasetAsync(String, String, CancellationToken, MySqlParameter)
	ExecuteDatasetAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
	ExecuteNonQuery(String, String, MySqlParameter)	Executes a single command against a MySQL database. A new MySqlConnection is created using the ConnectionString given.
	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.
	ExecuteNonQueryAsync(String, String, MySqlParameter)	Async version of ExecuteNonQuery
	ExecuteNonQueryAsync(MySqlConnection, String, MySqlParameter)	Async version of ExecuteNonQuery
	ExecuteNonQueryAsync(String, String, CancellationToken, MySqlParameter)
	ExecuteNonQueryAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
	ExecuteReader(String, String)	Executes a single command against a MySQL database.
	ExecuteReader(MySqlConnection, String)	Executes a single command against a MySQL database.
	ExecuteReader(String, String, MySqlParameter)	Executes a single command against a MySQL database.
	ExecuteReader(MySqlConnection, String, MySqlParameter)	Executes a single command against a MySQL database.
	ExecuteReaderAsync(String, String)	Async version of ExecuteReader
	ExecuteReaderAsync(MySqlConnection, String)	Async version of ExecuteReader
	ExecuteReaderAsync(String, String, MySqlParameter)	Async version of ExecuteReader
	ExecuteReaderAsync(String, String, CancellationToken)
	ExecuteReaderAsync(MySqlConnection, String, MySqlParameter)	Async version of ExecuteReader
	ExecuteReaderAsync(MySqlConnection, String, CancellationToken)
	ExecuteReaderAsync(String, String, CancellationToken, MySqlParameter)
	ExecuteReaderAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
	ExecuteScalar(String, String)	Execute a single command against a MySQL database.
	ExecuteScalar(MySqlConnection, String)	Execute a single command against a MySQL database.
	ExecuteScalar(String, String, MySqlParameter)	Execute a single command against a MySQL database.
	ExecuteScalar(MySqlConnection, String, MySqlParameter)	Execute a single command against a MySQL database.
	ExecuteScalarAsync(String, String)	Async version of ExecuteScalar
	ExecuteScalarAsync(MySqlConnection, String)	Async version of ExecuteScalar
	ExecuteScalarAsync(String, String, MySqlParameter)	Async version of ExecuteScalar
	ExecuteScalarAsync(String, String, CancellationToken)
	ExecuteScalarAsync(MySqlConnection, String, MySqlParameter)	Async version of ExecuteScalar
	ExecuteScalarAsync(MySqlConnection, String, CancellationToken)
	ExecuteScalarAsync(String, String, CancellationToken, MySqlParameter)
	ExecuteScalarAsync(MySqlConnection, String, CancellationToken, MySqlParameter)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)
	UpdateDataSet	Updates the given table with data from the given DataSet
	UpdateDataSetAsync(String, String, DataSet, String)	Async version of UpdateDataset
	UpdateDataSetAsync(String, String, DataSet, String, CancellationToken)

Top

Reference

MySql.Data.MySqlClient Namespace

Send comments on this topic to [email protected]

previous page start next page