Using MySQL from C# and Mono.NET

using System;
using System.Configuration;
using ByteFX.Data;
using System.IO;
using System.Reflection;

public class MySQLConsole
{
	private static string connectionString = string.Empty;
	private static string databaseName = string.Empty;
	private static ByteFX.Data.MySqlClient.MySqlConnection mysqlConn;

	public static void Main(string[] args)
	{
		try
		{
			connectionString = ConfigurationSettings.AppSettings["mysqlConnectionString"].ToString();
			Console.WriteLine("Please enter a new database name:");
			databaseName = Console.ReadLine();

			if(databaseName.Length > 0)
			{
				mysqlConn = new ByteFX.Data.MySqlClient.MySqlConnection();
				mysqlConn.ConnectionString = connectionString;
				mysqlConn.Open();

				//Create the sql script...
				string createdbSql = string.Format(
					"CREATE DATABASE {0}", databaseName);

				using(ByteFX.Data.MySqlClient.MySqlCommand cmd
					= new ByteFX.Data.MySqlClient.MySqlCommand(createdbSql, mysqlConn))
				{
					cmd.ExecuteNonQuery();

					Console.WriteLine(string.Format(
						"Database {0} successfully created", databaseName));
				}

			}

		}
		catch(Exception ex)
		{
			Console.WriteLine(ex.Message.ToString());
		}
		finally
		{
			if(mysqlConn != null)
			{
				mysqlConn.Close();
				mysqlConn.Dispose();
			}
		}

	}
	
}