[Mono-list] [OT] To Daniel Morgan

Carlos Guzman Alvarez carlosga@telefonica.net
Tue, 06 May 2003 13:56:08 +0200


Hello:


Sorry for sent this email to the list but all if i send it to daniel 
morgan email it goes back rejected.

Current version is Release Candidate 3, version 1.0 will be released soon.

There are a new developement branch for 1.1 version, that will have some 
new features ( but it's no tested with mono yet ):


- Updated API Reference documentation.

- New FbDatabaseInfo class, that allows to retrieve information about a 
connection to a FirebidSQL Server.

- Array data type support.

- CommandPlan property, that allows to retrive the query optimization 
plan, to FbCommand class.

- ExecuteScript method, that allows basic ISQL script execution, to 
FbCommand class.

- HasRows property to FbDataReader class.

- Better charset/encoding support.

The sample for the Firebird provider existent in go-mono is wrong, here 
is a fixed version:


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

  public class Test
  {
     public static void Main(string[] args)
     {
         string connectionString =
            "Database=C:\\PROGRAM 
FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
            "User=SYSDBA;" +
            "Password=masterkey;" +
            "Dialect=3;" +
            "Server=localhost";
        IDbConnection dbcon = new FbConnection(connectionString);
        dbcon.Open();
        IDbTransaction dbtxn = dbcon.BeginTransasction();
        IDbCommand dbcmd = dbcon.CreateCommand();
        string sql = "SELECT * FROM employee";
        dbcmd.Transaction = dbtxn;
        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;
     }
  }




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.