using System;
using System.Data;
using MySql.Data.MySqlClient;
 
public class Hauptprogramm
{
  public static void Main(string[] args)
  {
    IDbConnection dbcon = new MySqlConnection("Server=localhost;" +
					      "Database=test;" +
					      "User ID=testuser;" +
					      "Password=testuserpassword;");
    dbcon.Open();

    IDbCommand dbcmd = dbcon.CreateCommand();     
    dbcmd.CommandText = "select vorname, nachname from angestellter";

    IDataReader reader = dbcmd.ExecuteReader();
    while(reader.Read()) {
      string vorname = (string) reader["vorname"];
      string nachname = (string) reader["nachname"];
      Console.WriteLine(vorname + " " + nachname);
    }
     
    reader.Close();
    dbcmd.Dispose();
    dbcon.Close();
  }
}