Csharp/C Sharp/Database ADO.net/MySQL

Connection to MySql

<source lang="csharp"> using System; using System.Data; using ByteFX.Data.MySqlClient;

  class MySqlConnect
  {
     static void Main() 
     {
        string connString = @"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false";
        MySqlConnection conn = new MySqlConnection(connString);
        try 
        {
           conn.Open();
           Console.WriteLine("Connection opened.");
           Console.WriteLine("Connection Properties:");   
           Console.WriteLine("\tConnection String: {0}",conn.ConnectionString);    
           Console.WriteLine("\tDatabase: {0}",conn.Database);   
           Console.WriteLine("\tServerVersion: {0}",
              conn.ServerVersion);
           Console.WriteLine(
              "\tState: {0}",
              conn.State);
        } 
        catch (MySqlException e) 
        {
           Console.WriteLine("Error: " + e);  
        }
        finally 
        {
           conn.Close();
           Console.WriteLine("Connection closed.");
        }
     }
  }

      </source>