MySqlConnectionStringBuilder Class
Generates automatically connection strings used to connect to MySQL.
This sample shows how to construct a connection string and pass it to
MySqlConnection object.
|
|---|
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 mySqlConnection = new MySqlConnection(myCSB.ConnectionString);
mySqlConnection.Open();
Console.WriteLine(mySqlConnection.ServerVersion);
mySqlConnection.Close();
} |
|
|---|
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 mySqlConnection As MySqlConnection = New MySqlConnection(myCSB.ConnectionString)
mySqlConnection.Open()
Console.WriteLine(mySqlConnection.ServerVersion)
mySqlConnection.Close()
End Sub |