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
23 create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
30 <li>Currently, it is able to connect to Firebird and Interbase databases
31 and execute commands</li>
34 provider/driver is written in C# and provides a high-performance native
35 implementation of the GDS32/API functions. This means that .Net developers
36 will be able to access Firebird databases without the need of Firebird
39 <li>In support of the new module, a new mailing list
40 <a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a> has
41 been created. Please use this list for any
42 questions that you may have about the provider</li>
46 <li>Currently implemented classes:
\r
48 <li>Connection and Connection Pooling</li>
\r
50 <li>Transaction</li>
\r
51 <li>CommandBuilder</li>
\r
52 <li>DataAdapter</li>
\r
55 <li>ErrorCollection</li>
\r
58 <li>ParameterCollection</li>
\r
59 <li>Transaction</li>
\r
71 <li>Improving API reference documentation</li>
\r
72 <li>Full testing with Firebird 1.5</li>
\r
73 <li>Test with Mono ( http://www.go-mono.com )
\r
75 <li>Status : Started</li>
\r
79 <li>Support for array datatype
\r
81 <li>Status : Started</li>
\r
82 <li>Comments: See Interbase API reference documentation</li>
\r
83 <li>Add new file FbArray.cs for array fields management</li>
\r
87 <li>Support for Stored Procs calls that have returns values
\r
89 <li>Status : Pending.</li>
\r
90 <li>Comments: Modify the isc_dsql_prepare method of GDS implementation for
\r
91 allow to return the output parameters.</li>
\r
95 <li>Implementation of FbClientPermission and FbClientPermissionAttribute
\r
97 <li>Status : Pending</li>
\r
98 <li>Comments: See if these are really needed for Firebird</li>
\r
102 <li>Improve Logger implementation
\r
104 <li>Status: Pending</li>
114 <li>Need a working mono and mcs</li>
116 <li>Need access to a Firebird Relational Database or you can download
117 it from <a href="http://firebird.sourceforge.net">here</a></li>
119 <li>Get the Firebird .NET data provider from here as
120 <a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a>. Make
121 sure the Firebird .NET data provider binary assembly FirebirdSql.Data.Firebird.dll is
122 installed in the same place as the mono class libraries.</li>
124 <li>Has a ConnectionString format:
126 "Database=databasefile.gdb;User=user;Password=pass;Dialect=3;Server=hostname"
136 using FirebirdSql.Data.Firebird;
140 public static void Main(string[] args)
142 string connectionString =
\r
143 "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
\r
145 "Password=masterkey;" +
\r
147 "Server=localhost";
\r
148 IDbConnection dbcon = new FbConnection(connectionString);
150 IDbCommand dbcmd = dbcon.CreateCommand();
151 string sql = "SELECT * FROM employee";
152 dbcmd.CommandText = sql;
153 IDataReader reader = dbcmd.ExecuteReader();
154 while(reader.Read()) {
155 object dataValue = myReader.GetValue(0);
156 string sValue = dataValue.ToString();
157 Console.WriteLine("Value: " + sValue);
170 <li>Building C# Example:
172 <li>Save the example to a file, such as, TestExample.cs</li>
175 mcs TestExample.cs -r System.Data.dll \
176 -r FirebirdSql.Data.Firebird.dll
179 <li>Build on Windows via Cygwin:
181 mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
183 -lib:C:/cygwin/home/MyHome/mono/install/lib \
184 -r System.Data.dll -r FirebirdSql.Data.Firebird.dll
189 <li>Running the Example: