dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlConnection Class
Properties Methods Events

In This Topic
    MySqlConnection Class Members
    In This Topic

    The following tables list the members exposed by MySqlConnection.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the MySqlConnection class.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets charset that will be used on the client side.  
    Public PropertyGets the version of MySQL Client library (libmysql.dll or libmysqld.dll).  
    Public PropertyGets or sets a value indicating whether to enable transferred data compression.  
    Public PropertyOverridden. Gets or sets the string used to open a MySQL connection.  
    Public PropertyGets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyGets or sets the name of the current database or the database to be used once a connection is open.  
    Public PropertyGets or sets name of the server to which to connect. (Inherited from Devart.Common.DbConnectionBase)
    Public PropertyGets or sets a value indicating whether the MySQL client library (libmysql.dll) is be used.  
    Public PropertySpecifies, what server will be used to connect - MySQL server or Embedded MySQL server.  
    Public PropertyGets or sets name or IP address of host of MySQL database to which to connect.  
    Public PropertyGets the version of MySQL server to which to connect.  
    Public PropertyGets or sets connection options for HTTP tunneling.  
    Public PropertyIndicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase)
    Public PropertyGets or sets a value indicating whether a failover operation can be performed after connection breaks.  
    Public PropertyGets or sets the name of the component.  
    Public PropertyGets or sets a form or other container that the MySqlConnection instance belongs to.  
    Public PropertyGets or sets the user's password to connect.  
    Public PropertyGets or sets the interval (in seconds) between pinging MySQL server and reopening the connection if required.  
    Public PropertyGets or sets port of MySQL server to which to connect.  
    Public PropertyGets or sets a MySqlProtocol of the MySqlConnection.  
    Public PropertyGets the version of MySQL protocol.  
    Public PropertyGets or sets proxy server settings.  
    Public Property  
    Public PropertyGets a string containing the version of the instance of MySQL to which the client is connected.  
    Public Property  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyGets or sets SshOptions object which is used to establish secure connection with server.  
    Public PropertyGets or sets SslOptions object which is used to establish secure connection with server.  
    Public PropertyGets the current state of the connection.  
    Public PropertyGets or sets a value indicating whether the UTF8 charset will be used.  
    Public PropertyObsolete. Use UserId property instead.  
    Public PropertyGets or sets the name of the user to connect.  
    Top
    Public Methods
     NameDescription
    Public MethodStarts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodOverloaded. Begins a transaction at the database.  
    Public MethodOverridden. Changes the current database associated with an open connection.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Clears all pools associated with the connection.  
    Public Methodstatic (Shared in Visual Basic)Clears the pool matching ConnectionString of provided MySqlConnection object.  
    Public MethodCreates a new object that is a copy of the current instance.  
    Public MethodOverridden. Closes the connection to the data source. This is the preferred method of closing any open connection.  
    Public MethodCommits the database transaction.  
    Public MethodCreates and returns a MySqlCommand object associated with the MySqlConnection.  
    Public Method (Inherited from System.MarshalByRefObject)
    Public Method (Inherited from System.ComponentModel.Component)
    Public MethodEnds an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase)
    Public MethodEnlists in the specified transaction. (Inherited from Devart.Common.DbConnectionBase)
    Public Method (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase)
    Public Method (Inherited from System.MarshalByRefObject)
    Public MethodTerminates given connection to server.  
    Public MethodOverridden. Opens a MySQL connection with the property settings specified by the ConnectionString.  
    Public MethodDetermines whether connection to MySQL server is valid.  
    Public MethodRolls back a transaction from a pending state.  
    Public Method (Inherited from System.ComponentModel.Component)
    Top
    Public Events
     NameDescription
    Public EventThe event occurs when performing keyboard-interactive authentication.  
    Public EventThis event occurs when connection is lost.  
    Public Event (Inherited from System.ComponentModel.Component)
    Public EventOccurs when MySQL returns an error.  
    Public EventOccurs when MySQL returns a warning or informational message.  
    Public EventThe event occurs when host key verification during establishing connection failed.  
    Public EventOccurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase)
    Public EventOccurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase)
    Public EventOccurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase)
    Top
    See Also