Navigation

MySQL

From Mono

Info

The Mono provider for MySQL (http://www.mysql.com/) database is the MySQL Connector/Net (http://dev.mysql.com/downloads/connector/net/).

MySQL Connector/Net is a fully managed provider and does not require a client library. You have to get it from MySQL AB. The provider is distributed under the GPL license. This is the recommened provider to use with Mono.

Note: The 1.0.5 release of MySQL Connector/Net does not work on non-Windows systems.

Please download and use the 1.0.7 release of MySQL Connector/Net which works on Mono on Windows and Linux.

Support for MySQL Connector/Net can be found here (http://dev.mysql.com/support/)

ByteFX.Data is no longer maintained. You should use the MySQL Connector/Net instead.

Using

Prerequisites

  • Have access to a MySQL database or download it from MySQL AB (http://www.mysql.com/downloads/index.html)
  • MySQL data provider. Either ByteFX.Data that is included with Mono or the MySQL Connector/Net.

Connection String Format

  • Has a ConnectionString format: 
 "Server=hostname;" + "Database=database;" + "User ID=username;" + "Password=password;" + "Pooling=false"
  • Connection String Parameters:
Parameter Definition Description Example
Server or Data Source Hostname or IP Address of the MySQL server Server=MYHOST
Database name of MySQL database Database=testdb
Port TCP/IP Port to connect. Optional. Port=3306
User ID name of MySQL database user User ID=someuser
Password password for MySQL database user Password=mypass12
Pooling whether or not to use connection pooling. YES or TRUE to use connection pooling and NO or FALSE to not use connection pooling. Pooling=false
  • Installing MySql.Data.dll in the GAC: 
  cd path_to_your MySql.Data.dll assembly
  gacutil -i MySql.Data.dll
C# Example 
 using System;
 using System.Data;
 using MySql.Data.MySqlClient;
 
 public class Test
 {
    public static void Main(string[] args)
    {
       string connectionString =
          "Server=localhost;" +
          "Database=test;" +
          "User ID=myuserid;" +
          "Password=mypassword;" +
          "Pooling=false";
       IDbConnection dbcon;
       dbcon = new MySqlConnection(connectionString);
       dbcon.Open();
       IDbCommand dbcmd = dbcon.CreateCommand();
       // requires a table to be created named employee
       // with columns firstname and lastname
       // such as,
       //        CREATE TABLE employee (
       //           firstname varchar(32),
       //           lastname varchar(32));
       string sql =
           "SELECT firstname, lastname " +
           "FROM employee";
       dbcmd.CommandText = sql;
       IDataReader reader = dbcmd.ExecuteReader();
       while(reader.Read()) {
            string FirstName = (string) reader["firstname"];
            string LastName = (string) reader["lastname"];
            Console.WriteLine("Name: " +
                  FirstName + " " + LastName);
       }
       // clean up
       reader.Close();
       reader = null;
       dbcmd.Dispose();
       dbcmd = null;
       dbcon.Close();
       dbcon = null;
    }
 }
  • Building C# Example:
  • Save the example to a file, such as, TestExample.cs 
mcs TestExample.cs -r:System.Data.dll -r:/path/to/MySql.Data.dll
  • Running the Example: 
 mono TestExample.exe
Retrieved from "http://www.mono-project.com/MySQL"