"""
See also:
    docs/mysql on the Cobra web site
    http://www.mono-project.com/MySQL
    http://www.mono-project.com/Category:ADO.NET
    http://www.mono-project.com/Using_Databases

    "Installing Connector/NET on Unix with Mono"
    http://dev.mysql.com/doc/refman/5.0/en/connector-net-installation-unix.html

To run:
    cobra -r=System.Data -r=MySql.Data AccessMySQL.cobra

Or just compile:
    cobra -c -r=System.Data -r=MySql.Data AccessMySQL.cobra
and then run:
    mono mysql.exe

Mac OS X:
    For installation, MySQL docs say "Copy the MySql.Data.dll file to your Mono project installation folder."
    $ cp bin/MySql.Data.dll /Library/Frameworks/Mono.framework/Libraries/
"""

use System.Data
use MySql.Data.MySqlClient

class Program

    def main is shared
        connectionString = 'Server=localhost;Database=mysql;User ID=root;Password=;Pooling=false'
        using conn = MySqlConnection(connectionString) # IDbConnection
            conn.open
            using cmd = conn.createCommand # IDbCommand
                sql = 'select * from user;'
                cmd.commandText = sql
                using reader = cmd.executeReader # IDataReader
                    while reader.read
                        userName = reader['User']
                        host = reader['Host']
                        print 'userName=[userName], host=[host]'