[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.