X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=doc%2Ffirebird;h=76d7c7444bc7768e71648ca6553a9d0eedb97a19;hb=9d93ddc5daf9a96e7fcd5d9ef7fac0ddba68feb9;hp=066da551f58347abf270b61d8c0365ac11393da0;hpb=c099e72017e54753705e6b9ec27bd14c0646a782;p=mono.git
diff --git a/doc/firebird b/doc/firebird
index 066da551f58..76d7c7444bc 100755
--- a/doc/firebird
+++ b/doc/firebird
@@ -1,29 +1,36 @@
* Firebird and Interbase Data Provider
+ - ADO.NET Data Provider for Firebird and Interbase databases
+
- Does not exist in Mono, but is a separate project
- - Firebird Relational Database is
- an independent project which uses source code based on the Interbase source code released
+
- The Firebird Relational Database is
+ is an independent project which uses source code based on the Interbase source code released
by Borland under the Interbase Public License
- Both the Firebird Relational Database and the Firebird .NET Data Provider can be
- downloaded from here
+ downloaded from here
- The Firebird .NET Data provider has been made
- available by Carlos Guzmán Álvarez (aka "Carlos G.A."), who has also made a
- number of contributions to the OdbcJdbc code
+ available by Carlos Guzmán Álvarez (aka "Carlos G.A."), who has also made a
+ number of contributions to the OdbcJdbc code
+
+ - Bugs with Mono or the data provider should be reported
+ in Mono's Bugzilla here. If you
+ do not have Bugzilla user account, it is free
+ and easy to create one here.
-* Current Status
+** Current Status
-
- - Currently, it is able to connect to Firebird and Interbase databases
- and execute commands
-
- - The new data
- provider/driver is written in C# and provides a high-performance native
+
+ - Current stable version: 1.0
+
+ - Current developement version: 1.5
+
+ - The new data provider/driver is written in C# and provides a high-performance native
implementation of the GDS32/API functions. This means that .Net developers
will be able to access Firebird databases without the need of Firebird
client install
@@ -31,70 +38,116 @@
- In support of the new module, a new mailing list
firebird-net-provider has
been created. Please use this list for any
- questions that you may have about the provider
-
- - Stuff that works:
-
- - Currently implemented classes:
-
- - Connection and Connection Pooling
- - Command
- - Transaction
- - CommandBuilder
- - DataAdapter
- - DataReader
- - Error
- - ErrorCollection
- - Exception
- - Parameter
- - ParameterCollection
- - Transaction
-
-
-
-
-
+ questions that you may have about the provider
+
+** New features & enhancements in 1.5 version
+
+
+ - Better fit to ADO.NET
+
+ - New GDS implementation
+
+ - Implicit transaction support
+
+ - Array datatype support
+
+ - Firebird services API support
+
+ - Firebird events API support
+
+ - Stored procedure calls using Sql Server style
+
+ - Support for retrieve database schema information ( FbConnection.GetDbSchema )
+
+ - Improved Commandbuilder implementation
+
-* Action Plan
+** Testing
- - Bug fixing
- - Improving API reference documentation
- - Full testing with Firebird 1.5
- - Test with Mono ( http://www.go-mono.com )
-
-
-
- - Support for array datatype
-
- - Status : Started
- - Comments: See Interbase API reference documentation
- - Add new file FbArray.cs for array fields management
-
-
-
- - Support for Stored Procs calls that have returns values
-
- - Status : Pending.
- - Comments: Modify the isc_dsql_prepare method of GDS implementation for
- allow to return the output parameters.
-
-
-
- - Implementation of FbClientPermission and FbClientPermissionAttribute
-
- - Status : Pending
- - Comments: See if these are really needed for Firebird
-
-
-
- - Improve Logger implementation
-
+
+
- Need a working mono and mcs
+
+ - Need access to a Firebird Relational Database or you can download
+ it from here
+
+ - Get the Firebird .NET data provider from here as
+ firebird-net-provider. Make
+ sure the Firebird .NET data provider binary assembly FirebirdSql.Data.Firebird.dll is
+ installed in the same place as the mono class libraries.
+
+ - Has a ConnectionString format:
+
+ "Database=databasefile.gdb;User=user;Password=pass;Dialect=3;Server=hostname"
+
+
+
+ - C# Example:
+
+
+ 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();
+ IDbCommand dbcmd = dbcon.CreateCommand();
+ string sql = "SELECT * 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;
+ }
+ }
+
+
+ - Building C# Example:
+
+ - Save the example to a file, such as, TestExample.cs
+ - Build on Linux:
+
+ mcs TestExample.cs -r System.Data.dll \
+ -r FirebirdSql.Data.Firebird.dll
+
+
+ - Build on Windows via Cygwin:
+
+ mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
+ TestExample.cs \
+ -lib:C:/cygwin/home/MyHome/mono/install/lib \
+ -r System.Data.dll -r FirebirdSql.Data.Firebird.dll
+
+
+
+
+ - Running the Example:
+
+mono TestExample.exe
+
+
+
+
-