MySqlConnection Members

MySQL Connector.Net

previous page next page
Collapse image Expand Image Copy image CopyHover image

The MySqlConnection type exposes the following members.

Constructors

  Name Description
Public method MySqlConnection()()()()
Initializes a new instance of the MySqlConnection class.
Public method MySqlConnection(String)
Initializes a new instance of the MySqlConnection class when given a string containing the connection string.

Methods

  Name Description
Protected method BeginDbTransaction (Overrides DbConnection..::..BeginDbTransaction(IsolationLevel).)
Public method BeginTransaction()()()()
Begins a database transaction.
Public method BeginTransaction(IsolationLevel)
Begins a database transaction with the specified isolation level.
Public method BeginTransactionAsync()()()()
Async version of BeginTransaction
Public method BeginTransactionAsync(IsolationLevel)
Async version of BeginTransaction
Public method CancelQuery
Public method ChangeDatabase
Changes the current database for an open MySqlConnection.
(Overrides DbConnection..::..ChangeDatabase(String).)
Public method ChangeDataBaseAsync
Async version of ChangeDataBase
Public method Static member ClearAllPools
Clears all connection pools.
Public method ClearAllPoolsAsync
Async version of ClearAllPools
Public method Static member ClearPool
Empties the connection pool associated with the specified connection.
Public method ClearPoolAsync
Async version of ClearPool
Public method Clone
Creates a new MySqlConnection object with the exact same ConnectionString value
Public method Close
Closes the connection to the database. This is the preferred method of closing any open connection.
(Overrides DbConnection..::..Close()()()().)
Public method CloseAsync
Async version of Close
Public method CreateCommand
Creates and returns a MySqlCommand object associated with the MySqlConnection.
Protected method CreateDbCommand (Overrides DbConnection..::..CreateDbCommand()()()().)
Public method CreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
Public method Dispose()()()()
Protected method Dispose(Boolean) (Overrides Component..::..Dispose(Boolean).)
Public method EnlistTransaction
Enlists in the specified transaction.
(Overrides DbConnection..::..EnlistTransaction(Transaction).)
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected method Finalize
Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.
(Inherited from Component.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Public method GetSchema()()()()
Returns schema information for the data source of this DbConnection.
(Overrides DbConnection..::..GetSchema()()()().)
Public method GetSchema(String)
Returns schema information for the data source of this DbConnection using the specified string for the schema name.
(Overrides DbConnection..::..GetSchema(String).)
Public method GetSchema(String, array<String>[]()[][])
Returns schema information for the data source of this DbConnection using the specified string for the schema name and the specified string array for the restriction values.
(Overrides DbConnection..::..GetSchema(String, array<String>[]()[][]).)
Public method GetSchemaCollection
Public method GetSchemaCollectionAsync
Async version of GetSchemaCollection
Protected method GetService
Returns an object that represents a service provided by the Component or by its Container.
(Inherited from Component.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method InitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected method MemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Protected method OnStateChange
Raises the StateChange event.
(Inherited from DbConnection.)
Public method Open
Opens a database connection with the property settings specified by the ConnectionString.
(Overrides DbConnection..::..Open()()()().)
Public method OpenAsync
Async version of Open
Public method Ping
Ping
Public method ToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)

Properties

  Name Description
Protected property CanRaiseEvents
Gets a value indicating whether the component can raise an event.
(Inherited from Component.)
Public property ConnectionString
Gets or sets the string used to connect to a MySQL Server database.
(Overrides DbConnection..::..ConnectionString.)
Public property ConnectionTimeout
Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.
(Overrides DbConnection..::..ConnectionTimeout.)
Public property Container
Gets the IContainer that contains the Component.
(Inherited from Component.)
Public property Database
Gets the name of the current database or the database to be used after a connection is opened.
(Overrides DbConnection..::..Database.)
Public property DataSource
Gets the name of the MySQL server to which to connect.
(Overrides DbConnection..::..DataSource.)
Protected property DbProviderFactory (Overrides DbConnection..::..DbProviderFactory.)
Protected property DesignMode
Gets a value that indicates whether the Component is currently in design mode.
(Inherited from Component.)
Protected property Events
Gets the list of event handlers that are attached to this Component.
(Inherited from Component.)
Public property IsPasswordExpired
Public property ServerThread
Returns the id of the server thread this connection is executing on
Public property ServerVersion
Gets a string containing the version of the MySQL server to which the client is connected.
(Overrides DbConnection..::..ServerVersion.)
Public property Site
Gets or sets the ISite of the Component.
(Inherited from Component.)
Public property State
Gets the current state of the connection.
(Overrides DbConnection..::..State.)
Public property UseCompression
Indicates if this connection should use compression when communicating with the server.

Events

  Name Description
Public event Disposed
Occurs when the component is disposed by a call to the Dispose()()()() method.
(Inherited from Component.)
Public event InfoMessage
Occurs when MySQL returns warnings as a result of executing a command or query.
Public event StateChange
Occurs when the state of the event changes.
(Inherited from DbConnection.)

See Also

previous page start next page