using System;
using System.Data;
using FirebirdSql.Data.Firebird;

public class Test {
   public static void Main(string[] args) {
   string connectionString =
         "Database=/opt/firebird/examples/empbuild/employee.fdb;" +
         "User=SYSDBA;" + "Password=masterkey;" +
         "Dialect=3;" + "Server=localhost";

   IDbConnection dbcon = new FbConnection(connectionString);
   dbcon.Open();
   IDbCommand dbcmd = dbcon.CreateCommand();
   string sql = "SELECT FIRST 10 * FROM employee";
   dbcmd.CommandText = sql;
   IDataReader reader = dbcmd.ExecuteReader();
   while(reader.Read()) {
      object dataValue = reader.GetValue(0);
      string sValue = dataValue.ToString();
      Console.WriteLine("Value: " + sValue);
      }

   // clean up
   reader.Close();
   reader = null;
   dbcmd.Dispose();
   dbcmd = null;
   dbcon.Close();
   dbcon = null;
   }
}