X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=web%2Ffirebird;h=6d3bc0b33f32c63411cae8580a7aa00349afd31f;hb=a17adea98d0e3b4b130ba2d3c65521c26e7f32a7;hp=c5dd3d55de98968e7410cfbdd0ccacc685b02ab1;hpb=25fc0f820b8f22187d78fb66bf7d35ccd7fe0224;p=mono.git

diff --git a/web/firebird b/web/firebird
index c5dd3d55de9..6d3bc0b33f3 100755
--- a/web/firebird
+++ b/web/firebird
@@ -1,57 +1,140 @@
 * Firebird and Interbase Data Provider
 
 <ul>
+	<li>ADO.NET Data Provider for Firebird and Interbase databases</li>
+
 	<li>Does not exist in Mono, but is a separate project</li>
 	
-	<li><a href="http://firebird.sourceforge.net/index.php">Firebird Relational Database</a> is 
-	an independent project which uses source code based on the Interbase source code released
-	by Borland under the Interbase Public License.</li>
+	<li>The <a href="http://firebird.sourceforge.net/index.php">Firebird Relational Database</a> is 
+	is an independent project which uses source code based on the Interbase source code released
+	by Borland under the Interbase Public License</li>
 	
 	<li>Both the Firebird Relational Database and the Firebird .NET Data Provider can be
-	downloaded from <a href="http://sourceforge.net/projects/firebird/firebird">here</a></li>
+	downloaded from <a href="http://sourceforge.net/projects/firebird/">here</a></li>
 	
 	<li>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.</li>
- 
-	<li>Stuff that works:
-		<ul>
-			<li>CommandBuilder</li>
-            <li>DataReader</li>
-            <li>SchemaTable</li>
-            <li>DataAdapter</li>
-            <li>BatchQuerys</li>
-            <li>ExecuteNonQuery</li>
-        </ul>
-	</li>
+    available by Carlos Guzmán Álvarez (aka "Carlos G.A."), who has also made a
+    number of contributions to the OdbcJdbc code</li>
+
+	<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>
 	
 </ul>
 
-* Current Status
+** 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>
+        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>CommandBuilder works</li>
- 
+        questions that you may have about the provider</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>
    
-* Action Plan
+** Testing
 
 <ul>
-	<li>Get it to work on Mono too</li>
 	
-	<li>Connection Pooling.</li>
-</ul>	
+	<li>Need a working mono and mcs</li>
+	
+	<li>Need access to a Firebird Relational Database or you can download
+	it from <a href="http://firebird.sourceforge.net">here</a></li>
+	
+	<li>Get the Firebird .NET data provider from here as 
+	<a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a>.  Make
+	sure the Firebird .NET data provider binary assembly FirebirdSql.Data.Firebird.dll is
+	installed in the same place as the mono class libraries.</li>
+	
+	<li>Has a ConnectionString format:
+<pre>
+ "Database=databasefile.gdb;User=user;Password=pass;Dialect=3;Server=hostname"
+</pre>
+	
+	</li>
+	
+	<li>C# Example:
+	
+<pre>
+ 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;
+    }
+ }
+</pre>
+	</li>
+	<li>Building C# Example:
+	<ul>
+		<li>Save the example to a file, such as, TestExample.cs</li>
+		<li>Build on Linux:
+<pre>
+	mcs TestExample.cs -r System.Data.dll \
+	    -r FirebirdSql.Data.Firebird.dll
+</pre>
+		</li>
+		<li>Build on Windows via Cygwin:
+<pre>
+	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
+</pre>
+		</li>
+	</ul>
+	</li>
+	<li>Running the Example:
+<pre>
+mono TestExample.exe
+</pre>
+</li>
+
+</ul>
+