1 * Firebird and Interbase Data Provider
4 <li>ADO.NET Data Provider for Firebird and Interbase databases</li>
6 <li>Does not exist in Mono, but is a separate project</li>
8 <li>The <a href="http://firebird.sourceforge.net/index.php">Firebird Relational Database</a> is
9 is an independent project which uses source code based on the Interbase source code released
10 by Borland under the Interbase Public License</li>
12 <li>Both the Firebird Relational Database and the Firebird .NET Data Provider can be
13 downloaded from <a href="http://sourceforge.net/projects/firebird/">here</a></li>
15 <li>The Firebird .NET Data provider has been made
16 available by Carlos Guzmán Álvarez (aka "Carlos G.A."), who has also made a
17 number of contributions to the OdbcJdbc code</li>
19 <li>Bugs with Mono or the data provider should be reported
20 in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>. If you
21 do not have Bugzilla user account, it is free
22 and easy to create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
29 <li>Current stable version: 1.0</li>
31 <li>Current developement version: 1.5</li>
33 <li>The new data provider/driver is written in C# and provides a high-performance native
34 implementation of the GDS32/API functions. This means that .Net developers
35 will be able to access Firebird databases without the need of Firebird
38 <li>In support of the new module, a new mailing list
39 <a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a> has
40 been created. Please use this list for any
41 questions that you may have about the provider</li>
44 ** New features & enhancements in 1.5 version
47 <li>Better fit to ADO.NET</li>
49 <li>New GDS implementation</li>
51 <li>Implicit transaction support</li>
53 <li>Array datatype support</li>
55 <li>Firebird services API support</li>
57 <li>Firebird events API support</li>
59 <li>Stored procedure calls using Sql Server style</li>
61 <li>Support for retrieve database schema information ( FbConnection.GetDbSchema )</li>
63 <li>Improved Commandbuilder implementation</li>
70 <li>Need a working mono and mcs</li>
72 <li>Need access to a Firebird Relational Database or you can download
73 it from <a href="http://firebird.sourceforge.net">here</a></li>
75 <li>Get the Firebird .NET data provider from here as
76 <a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a>. Make
77 sure the Firebird .NET data provider binary assembly FirebirdSql.Data.Firebird.dll is
78 installed in the same place as the mono class libraries.</li>
80 <li>Has a ConnectionString format:
82 "Database=databasefile.gdb;User=user;Password=pass;Dialect=3;Server=hostname"
92 using FirebirdSql.Data.Firebird;
96 public static void Main(string[] args)
98 string connectionString =
99 "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
101 "Password=masterkey;" +
105 IDbConnection dbcon = new FbConnection(connectionString);
107 IDbCommand dbcmd = dbcon.CreateCommand();
108 string sql = "SELECT * FROM employee";
109 dbcmd.CommandText = sql;
110 IDataReader reader = dbcmd.ExecuteReader();
111 while(reader.Read()) {
112 object dataValue = reader.GetValue(0);
113 string sValue = dataValue.ToString();
114 Console.WriteLine("Value: " + sValue);
127 <li>Building C# Example:
129 <li>Save the example to a file, such as, TestExample.cs</li>
132 mcs TestExample.cs -r System.Data.dll \
133 -r FirebirdSql.Data.Firebird.dll
136 <li>Build on Windows via Cygwin:
138 mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
140 -lib:C:/cygwin/home/MyHome/mono/install/lib \
141 -r System.Data.dll -r FirebirdSql.Data.Firebird.dll
146 <li>Running the Example: