*** empty log message ***

[mono.git] / doc / firebird

diff --git a/doc/firebird b/doc/firebird
index 066da551f58347abf270b61d8c0365ac11393da0..9058c97088ff5073978e7cd9c61ac3536eee947a 100755 (executable)
--- a/doc/firebird
+++ b/doc/firebird
@@ -1,22 +1,30 @@
 * 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
+       <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>
+    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 
@@ -56,7 +64,7 @@
  
 </ul>   
    
-* Action Plan
+** Action Plan
 
 <ul>
        <li>Bug fixing</li>\r
@@ -98,3 +106,91 @@
        </li>
 
 </ul>  
+
+** Testing
+
+<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 = \r
+              "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +\r
+              "User=SYSDBA;" +\r
+              "Password=masterkey;" +\r
+              "Dialect=3;" +\r
+              "Server=localhost";\r
+       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 = myReader.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>
+