







![]() ![]() ![]() |
MySQL Connector/Net |
MySqlConnection Members |
MySqlConnection Class Constructors Methods Properties Events See Also Send Feedback |
![]() |
The MySqlConnection type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() |
MySqlConnection()()()() |
Initializes a new instance of the MySqlConnection class.
|
![]() |
MySqlConnection(String) |
Initializes a new instance of the MySqlConnection class when given a string containing the connection string.
|
Methods
Name | Description | |
---|---|---|
![]() |
BeginDbTransaction | (Overrides DbConnection..::..BeginDbTransaction(IsolationLevel).) |
![]() |
BeginTransaction()()()() |
Begins a database transaction.
|
![]() |
BeginTransaction(IsolationLevel) |
Begins a database transaction with the specified isolation level.
|
![]() |
BeginTransactionAsync()()()() |
Async version of BeginTransaction
|
![]() |
BeginTransactionAsync(IsolationLevel) |
Async version of BeginTransaction
|
![]() |
CancelQuery | |
![]() |
ChangeDatabase | Changes the current database for an open MySqlConnection. (Overrides DbConnection..::..ChangeDatabase(String).) |
![]() |
ChangeDataBaseAsync |
Async version of ChangeDataBase
|
![]() ![]() |
ClearAllPools |
Clears all connection pools.
|
![]() |
ClearAllPoolsAsync |
Async version of ClearAllPools
|
![]() ![]() |
ClearPool |
Empties the connection pool associated with the specified connection.
|
![]() |
ClearPoolAsync |
Async version of ClearPool
|
![]() |
Clone |
Creates a new MySqlConnection object with the exact same ConnectionString value
|
![]() |
Close | Closes the connection to the database. This is the preferred method of closing any open connection. (Overrides DbConnection..::..Close()()()().) |
![]() |
CloseAsync |
Async version of Close
|
![]() |
CreateCommand |
Creates and returns a MySqlCommand object associated with the MySqlConnection.
|
![]() |
CreateDbCommand | (Overrides DbConnection..::..CreateDbCommand()()()().) |
![]() |
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.) |
![]() |
Dispose()()()() | |
![]() |
Dispose(Boolean) | (Overrides Component..::..Dispose(Boolean).) |
![]() |
EnlistTransaction |
Enlists in the specified transaction.
(Overrides DbConnection..::..EnlistTransaction(Transaction).) |
![]() |
Equals | (Inherited from Object.) |
![]() |
Finalize | Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.) |
![]() |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
![]() |
GetSchema()()()() |
Returns schema information for the data source of this DbConnection.
(Overrides DbConnection..::..GetSchema()()()().) |
![]() |
GetSchema(String) |
Returns schema information for the data source of this
DbConnection using the specified string for the schema name.
(Overrides DbConnection..::..GetSchema(String).) |
![]() |
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>[]()[][]).) |
![]() |
GetSchemaCollection | |
![]() |
GetSchemaCollectionAsync |
Async version of GetSchemaCollection
|
![]() |
GetService | (Inherited from Component.) |
![]() |
GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
![]() |
MemberwiseClone()()()() | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() |
MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.) |
![]() |
OnStateChange | Raises the StateChange event. (Inherited from DbConnection.) |
![]() |
Open | Opens a database connection with the property settings specified by the ConnectionString. (Overrides DbConnection..::..Open()()()().) |
![]() |
OpenAsync |
Async version of Open
|
![]() |
Ping |
Ping
|
![]() |
ToString | Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.) |
Properties
Name | Description | |
---|---|---|
![]() |
CanRaiseEvents | Gets a value indicating whether the component can raise an event. (Inherited from Component.) |
![]() |
ConnectionString |
Gets or sets the string used to connect to a MySQL Server database.
(Overrides DbConnection..::..ConnectionString.) |
![]() |
ConnectionTimeout |
Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.
(Overrides DbConnection..::..ConnectionTimeout.) |
![]() |
Container | Gets the IContainer that contains the Component. (Inherited from Component.) |
![]() |
Database | Gets the name of the current database or the database to be used after a connection is opened. (Overrides DbConnection..::..Database.) |
![]() |
DataSource |
Gets the name of the MySQL server to which to connect.
(Overrides DbConnection..::..DataSource.) |
![]() |
DbProviderFactory | (Overrides DbConnection..::..DbProviderFactory.) |
![]() |
DesignMode | Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.) |
![]() |
Events | Gets the list of event handlers that are attached to this Component. (Inherited from Component.) |
![]() |
IsPasswordExpired | |
![]() |
ServerThread |
Returns the id of the server thread this connection is executing on
|
![]() |
ServerVersion | Gets a string containing the version of the MySQL server to which the client is connected. (Overrides DbConnection..::..ServerVersion.) |
![]() |
Site | (Inherited from Component.) |
![]() |
State | Gets the current state of the connection. (Overrides DbConnection..::..State.) |
![]() |
UseCompression |
Indicates if this connection should use compression when communicating with the server.
|
Events
Name | Description | |
---|---|---|
![]() |
Disposed | Occurs when the component is disposed by a call to the Dispose()()()() method. (Inherited from Component.) |
![]() |
InfoMessage |
Occurs when MySQL returns warnings as a result of executing a command or query.
|
![]() |
StateChange | Occurs when the state of the event changes. (Inherited from DbConnection.) |