MySqlConnectionStringBuilder Class

In This Topic

Generates automatically connection strings used to connect to MySQL.

Syntax

Visual Basic
C#

'Declaration
 
Public Class MySqlConnectionStringBuilder 
   Inherits Devart.Common.DbConnectionStringBuilder
   Implements System.Collections.ICollection, System.Collections.IDictionary, System.Collections.IEnumerable, System.ComponentModel.ICustomTypeDescriptor

public class MySqlConnectionStringBuilder : Devart.Common.DbConnectionStringBuilder, System.Collections.ICollection, System.Collections.IDictionary, System.Collections.IEnumerable, System.ComponentModel.ICustomTypeDescriptor

Remarks

The MySqlConnectionStringBuilder allows you to construct a connection string by assigning values to corresponding properties. After you have initialized all connection properties you need, use System.Data.Common.DbConnectionStringBuilder.ConnectionString property or ToString method to obtain the connection string built.

Example

This sample shows how to construct a connection string and pass it to MySqlConnection object.

csharp

public void UseConnectionStringBuilder()
{
  MySqlConnectionStringBuilder myCSB = new MySqlConnectionStringBuilder();
  myCSB.Port = 3306;
  myCSB.Host = "localhost";
  myCSB.UserId = "root";
  myCSB.Direct = true;
  myCSB.Compress = true;
  myCSB.Database = "demobase";
  myCSB.MaxPoolSize = 50;
  MySqlConnection myConnection = new MySqlConnection(myCSB.ConnectionString);
  myConnection.Open();
  Console.WriteLine(myConnection.ServerVersion);
  myConnection.Close();
}

Visual Basic

Public Sub UseConnectionStringBuilder()
  Dim myCSB As MySqlConnectionStringBuilder = New MySqlConnectionStringBuilder
  myCSB.Port = 3306
  myCSB.Host = "localhost"
  myCSB.UserId = "root"
  myCSB.Direct = True
  myCSB.Compress = True
  myCSB.Database = "demobase"
  myCSB.MaxPoolSize = 50
  Dim myConnection As MySqlConnection = New MySqlConnection(myCSB.ConnectionString)
  myConnection.Open()
  Console.WriteLine(myConnection.ServerVersion)
  myConnection.Close()
End Sub

Inheritance Hierarchy

System.Object
   System.Data.Common.DbConnectionStringBuilder
      Devart.Common.DbConnectionStringBuilder
         Devart.Data.MySql.MySqlConnectionStringBuilder

Reference

MySqlConnectionStringBuilder Members
Devart.Data.MySql Namespace
ConnectionString Property

Send Feedback