• Overview
  • MySQL Data
  • MySQL Entity Framework
  • MySQL Entity Framework Core
  • MySQL Web
  • MySQL Data
  • MySql.Data.MySqlClient
  • MySqlHelper
Search Results for

    Show / Hide Table of Contents
    • MySql.Data
      • PacketBitConverter
    • MySql.Data.MySqlClient
      • AuthenticationPluginConfigurationElement
      • BaseCommandInterceptor
      • BaseTableCache
      • CharacterSet
      • CloseNotification
      • CompressionAlgorithms
      • CompressionType
      • GenericConfigurationElementCollection<T>
      • InterceptorConfigurationElement
      • KerberosAuthMode
      • LockContention
      • MySqlAttribute
      • MySqlAttributeCollection
      • MySqlAuthenticationMode
      • MySqlBaseConnectionStringBuilder
      • MySqlBulkLoader
      • MySqlBulkLoaderConflictOption
      • MySqlBulkLoaderPriority
      • MySqlCertificateStoreLocation
      • MySqlClientFactory
      • MySqlClientPermission
      • MySqlClientPermissionAttribute
      • MySqlCommand
      • MySqlCommandBuilder
      • MySqlConfiguration
      • MySqlConnection
      • MySqlConnectionProtocol
      • MySqlConnectionStringBuilder
      • MySqlDataAdapter
      • MySqlDataReader
      • MySqlDbType
      • MySqlDriverType
      • MySqlError
      • MySqlErrorCode
      • MySqlException
      • MySqlGuidFormat
      • MySqlHelper
      • MySqlInfoMessageEventArgs
      • MySqlInfoMessageEventHandler
      • MySqlParameter
      • MySqlParameterCollection
      • MySqlRowUpdatedEventArgs
      • MySqlRowUpdatedEventHandler
      • MySqlRowUpdatingEventArgs
      • MySqlRowUpdatingEventHandler
      • MySqlSchemaCollection
      • MySqlSchemaRow
      • MySqlScript
      • MySqlScriptErrorEventArgs
      • MySqlScriptErrorEventHandler
      • MySqlScriptEventArgs
      • MySqlSecurityPermission
      • MySqlSslMode
      • MySqlStatementExecutedEventHandler
      • MySqlTrace
      • MySqlTraceEventType
      • MySqlTransaction
      • ReplicationConfigurationElement
      • ReplicationServerConfigurationElement
      • ReplicationServerGroupConfigurationElement
      • SchemaColumn
      • UsageAdvisorWarningFlags
      • WebAuthnActionCallback
    • MySql.Data.MySqlClient.Authentication
      • MySqlAuthenticationPlugin
      • MySqlClearPasswordPlugin
      • MySqlNativePasswordPlugin
      • MySqlPemReader
    • MySql.Data.MySqlClient.Interceptors
      • BaseExceptionInterceptor
    • MySql.Data.MySqlClient.Replication
      • ReplicationRoundRobinServerGroup
      • ReplicationServer
      • ReplicationServerGroup
    • MySql.Data.MySqlClient.X.XDevAPI.Common
      • ColumnType
    • MySql.Data.Types
      • MySqlConversionException
      • MySqlDateTime
      • MySqlDecimal
      • MySqlGeometry
    • Mysqlx
      • ClientMessages
      • ClientMessages.Types
      • ClientMessages.Types.Type
      • Error
      • Error.Types
      • Error.Types.Severity
      • MysqlxExtensions
      • MysqlxReflection
      • Ok
      • ServerMessages
      • ServerMessages.Types
      • ServerMessages.Types.Type
    • Mysqlx.Connection
      • Capabilities
      • CapabilitiesGet
      • CapabilitiesSet
      • Capability
      • Close
      • Compression
      • MysqlxConnectionReflection
    • Mysqlx.Crud
      • Collection
      • Column
      • CreateView
      • DataModel
      • Delete
      • DropView
      • Find
      • Find.Types
      • Find.Types.RowLock
      • Find.Types.RowLockOptions
      • Insert
      • Insert.Types
      • Insert.Types.TypedRow
      • Limit
      • LimitExpr
      • ModifyView
      • MysqlxCrudReflection
      • Order
      • Order.Types
      • Order.Types.Direction
      • Projection
      • Update
      • UpdateOperation
      • UpdateOperation.Types
      • UpdateOperation.Types.UpdateType
      • ViewAlgorithm
      • ViewCheckOption
      • ViewSqlSecurity
    • Mysqlx.Cursor
      • Close
      • Fetch
      • MysqlxCursorReflection
      • Open
      • Open.Types
      • Open.Types.OneOfMessage
      • Open.Types.OneOfMessage.Types
      • Open.Types.OneOfMessage.Types.Type
    • Mysqlx.Datatypes
      • Any
      • Any.Types
      • Any.Types.Type
      • Array
      • MysqlxDatatypesReflection
      • Object
      • Object.Types
      • Object.Types.ObjectField
      • Scalar
      • Scalar.Types
      • Scalar.Types.Octets
      • Scalar.Types.String
      • Scalar.Types.Type
    • Mysqlx.Expect
      • Close
      • MysqlxExpectReflection
      • Open
      • Open.Types
      • Open.Types.Condition
      • Open.Types.Condition.Types
      • Open.Types.Condition.Types.ConditionOperation
      • Open.Types.Condition.Types.Key
      • Open.Types.CtxOperation
    • Mysqlx.Expr
      • Array
      • ColumnIdentifier
      • DocumentPathItem
      • DocumentPathItem.Types
      • DocumentPathItem.Types.Type
      • Expr
      • Expr.Types
      • Expr.Types.Type
      • FunctionCall
      • Identifier
      • MysqlxExprReflection
      • Object
      • Object.Types
      • Object.Types.ObjectField
      • Operator
    • Mysqlx.Notice
      • Frame
      • Frame.Types
      • Frame.Types.Scope
      • Frame.Types.Type
      • GroupReplicationStateChanged
      • GroupReplicationStateChanged.Types
      • GroupReplicationStateChanged.Types.Type
      • MysqlxNoticeReflection
      • ServerHello
      • SessionStateChanged
      • SessionStateChanged.Types
      • SessionStateChanged.Types.Parameter
      • SessionVariableChanged
      • Warning
      • Warning.Types
      • Warning.Types.Level
    • Mysqlx.Prepare
      • Deallocate
      • Execute
      • MysqlxPrepareReflection
      • Prepare
      • Prepare.Types
      • Prepare.Types.OneOfMessage
      • Prepare.Types.OneOfMessage.Types
      • Prepare.Types.OneOfMessage.Types.Type
    • MySqlX.Protocol
      • ProtocolBase
    • Mysqlx.Resultset
      • ColumnMetaData
      • ColumnMetaData.Types
      • ColumnMetaData.Types.FieldType
      • ContentType_BYTES
      • ContentType_DATETIME
      • FetchDone
      • FetchDoneMoreOutParams
      • FetchDoneMoreResultsets
      • FetchSuspended
      • MysqlxResultsetReflection
      • Row
    • MySqlX.Serialization
      • JsonParser
    • Mysqlx.Session
      • AuthenticateContinue
      • AuthenticateOk
      • AuthenticateStart
      • Close
      • MysqlxSessionReflection
      • Reset
    • Mysqlx.Sql
      • MysqlxSqlReflection
      • StmtExecute
      • StmtExecuteOk
    • MySqlX.XDevAPI
      • BaseSession
      • Client
      • Collection
      • Collection<T>
      • DatabaseObject
      • DbDoc
      • Iterator
      • MySqlExpression
      • MySQLX
      • MySqlXConnectionStringBuilder
      • Schema
      • Session
      • SessionState
    • MySqlX.XDevAPI.Common
      • BaseResult
      • BaseStatement<TResult, TType>
      • BufferingResult<T>
      • CreateCollectionOptions
      • ErrorInfo
      • FilterableStatement<T, TTarget, TResult, TDoc>
      • ModifyCollectionOptions
      • Result
      • TargetedBaseStatement<TTarget, TResult, TType>
      • Validation
      • ValidationLevel
      • WarningInfo
    • MySqlX.XDevAPI.CRUD
      • AddStatement<T>
      • CreateCollectionIndexStatement<T>
      • CrudStatement<TResult, T>
      • DocResult<T>
      • FindStatement<T>
      • ModifyStatement<T>
      • RemoveStatement<T>
    • MySqlX.XDevAPI.Relational
      • Column
      • InternalRowResult
      • Row
      • RowResult
      • SqlResult
      • SqlStatement
      • Table
      • TableDeleteStatement
      • TableInsertStatement
      • TableSelectStatement
      • TableUpdateStatement

    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
    In This Article
    • Methods
      • DoubleQuoteString(String)
      • EscapeString(String)
      • ExecuteDataRow(String, String, MySqlParameter[])
      • ExecuteDataRowAsync(String, String, MySqlParameter[])
      • ExecuteDataRowAsync(String, String, CancellationToken, MySqlParameter[])
      • ExecuteDataset(MySqlConnection, String)
      • ExecuteDataset(MySqlConnection, String, MySqlParameter[])
      • ExecuteDataset(String, String)
      • ExecuteDataset(String, String, MySqlParameter[])
      • ExecuteDatasetAsync(MySqlConnection, String)
      • ExecuteDatasetAsync(MySqlConnection, String, MySqlParameter[])
      • ExecuteDatasetAsync(MySqlConnection, String, CancellationToken)
      • ExecuteDatasetAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
      • ExecuteDatasetAsync(String, String)
      • ExecuteDatasetAsync(String, String, MySqlParameter[])
      • ExecuteDatasetAsync(String, String, CancellationToken)
      • ExecuteDatasetAsync(String, String, CancellationToken, MySqlParameter[])
      • ExecuteNonQuery(MySqlConnection, String, MySqlParameter[])
      • ExecuteNonQuery(String, String, MySqlParameter[])
      • ExecuteNonQueryAsync(MySqlConnection, String, MySqlParameter[])
      • ExecuteNonQueryAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
      • ExecuteNonQueryAsync(String, String, MySqlParameter[])
      • ExecuteNonQueryAsync(String, String, CancellationToken, MySqlParameter[])
      • ExecuteReader(MySqlConnection, String)
      • ExecuteReader(MySqlConnection, String, MySqlParameter[])
      • ExecuteReader(String, String)
      • ExecuteReader(String, String, MySqlParameter[])
      • ExecuteReaderAsync(MySqlConnection, String)
      • ExecuteReaderAsync(MySqlConnection, String, MySqlParameter[])
      • ExecuteReaderAsync(MySqlConnection, String, CancellationToken)
      • ExecuteReaderAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
      • ExecuteReaderAsync(String, String)
      • ExecuteReaderAsync(String, String, MySqlParameter[])
      • ExecuteReaderAsync(String, String, CancellationToken)
      • ExecuteReaderAsync(String, String, CancellationToken, MySqlParameter[])
      • ExecuteScalar(MySqlConnection, String)
      • ExecuteScalar(MySqlConnection, String, MySqlParameter[])
      • ExecuteScalar(String, String)
      • ExecuteScalar(String, String, MySqlParameter[])
      • ExecuteScalarAsync(MySqlConnection, String)
      • ExecuteScalarAsync(MySqlConnection, String, MySqlParameter[])
      • ExecuteScalarAsync(MySqlConnection, String, CancellationToken)
      • ExecuteScalarAsync(MySqlConnection, String, CancellationToken, MySqlParameter[])
      • ExecuteScalarAsync(String, String)
      • ExecuteScalarAsync(String, String, MySqlParameter[])
      • ExecuteScalarAsync(String, String, CancellationToken)
      • ExecuteScalarAsync(String, String, CancellationToken, MySqlParameter[])
      • UpdateDataSet(String, String, DataSet, String)
      • UpdateDataSetAsync(String, String, DataSet, String)
      • UpdateDataSetAsync(String, String, DataSet, String, CancellationToken)
    Back to top Copyright © 2021, 2025, Oracle and/or its affiliates.