<li>Bugs with Mono or the data provider should be reported
in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>. If you
do not have Bugzilla user account, it is free
- and easy to
- create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
+ and easy to create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
</ul>
** Current Status
-<ul>
- <li>Currently, it is able to connect to Firebird and Interbase databases
- and execute commands</li>
-
- <li>The new data
- provider/driver is written in C# and provides a high-performance native
+<ul>
+ <li>Current stable version: 1.5.1</li>
+
+ <li>Current developement version: 1.6</li>
+
+ <li>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</li>
<li>In support of the new module, a new mailing list
<a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a> has
been created. Please use this list for any
- questions that you may have about the provider</li>
-
- <li>Stuff that works:
- <ul>\r
- <li>Currently implemented classes: \r
- <ul>\r
- <li>Connection and Connection Pooling</li> \r
- <li>Command</li>\r
- <li>Transaction</li>\r
- <li>CommandBuilder</li>\r
- <li>DataAdapter</li>\r
- <li>DataReader</li>\r
- <li>Error</li>\r
- <li>ErrorCollection</li>\r
- <li>Exception</li>\r
- <li>Parameter</li>\r
- <li>ParameterCollection</li>\r
- <li>Transaction</li>\r
- </ul>\r
- </li> \r
- </ul>
- </li>
-
+ questions that you may have about the provider</li>
</ul>
-
-** Action Plan
-<ul>
- <li>Bug fixing</li>\r
- <li>Improving API reference documentation</li>\r
- <li>Full testing with Firebird 1.5</li>\r
- <li>Test with Mono ( http://www.go-mono.com )\r
- <ul>\r
- <li>Status : Started</li>\r
- </ul>\r
- </li>\r
- \r
- <li>Support for array datatype\r
- <ul>\r
- <li>Status : Started</li>\r
- <li>Comments: See Interbase API reference documentation</li>\r
- <li>Add new file FbArray.cs for array fields management</li>\r
- </ul>\r
- </li>\r
-\r
- <li>Support for Stored Procs calls that have returns values\r
- <ul>\r
- <li>Status : Pending.</li>\r
- <li>Comments: Modify the isc_dsql_prepare method of GDS implementation for\r
- allow to return the output parameters.</li>\r
- </ul>\r
- </li>\r
- \r
- <li>Implementation of FbClientPermission and FbClientPermissionAttribute\r
- <ul>\r
- <li>Status : Pending</li>\r
- <li>Comments: See if these are really needed for Firebird</li>\r
- </ul>\r
- </li>\r
-\r
- <li>Improve Logger implementation\r
- <ul>\r
- <li>Status: Pending</li>
- </ul>
- </li>
-
-</ul>
+** New features & enhancements in 1.6 version
+<ul>
+ <li>Firebird Embedded Server support.</li>
+ <li>New FbScript class implementation.</li>
+ <li>Improved connection pooling.</li>
+ <li>Improved array datatype support.</li>
+</ul>
+
** Testing
<ul>
{
public static void Main(string[] args)
{
- string connectionString = \r
- "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +\r
- "User=SYSDBA;" +\r
- "Password=masterkey;" +\r
- "Dialect=3;" +\r
- "Server=localhost";\r
+ 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();
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
while(reader.Read()) {
- object dataValue = myReader.GetValue(0);
+ object dataValue = reader.GetValue(0);
string sValue = dataValue.ToString();
Console.WriteLine("Value: " + sValue);
}