2009-04-24 Rodrigo Kumpera <kumpera@gmail.com>

[mono.git] / web / sqlite

diff --git a/web/sqlite b/web/sqlite
index 85b35c997aa708f627ba4615c9fcef169fd425c0..8c866571c4eca8f2c8d2f89e87849370ba1df891 100755 (executable)
--- a/web/sqlite
+++ b/web/sqlite
@@ -1,13 +1,38 @@
 * SQL Lite Data Provider
 
 <ul>
+       <li>ADO.NET Data Provider for 
+       the <a href"http://www.hwaci.com/sw/sqlite/">SQL Lite</a> which 
+       is an embeddable SQL database engine</li>
+
+       <li>From the SQL Lite web page: SQLite is a C library that \r
+       implements an embeddable SQL database engine. Programs that link with \r
+       the SQLite library can have SQL database access without \r
+       running a separate RDBMS process. The distribution \r
+       comes with a standalone command-line access program (sqlite) that \r
+       can be used to administer an SQLite database and which serves \r
+       as an example of how to use the SQLite library.  SQLite is not a client library \r
+       used to connect to a big database server. SQLite is the server. The SQLite \r
+       library reads and writes directly to and from the database files on disk.</li>\r
+
+       <li>SQL Lite can be downloaded 
+       from <a href="http://www.hwaci.com/sw/sqlite/download.html">here</a>.
+       binaries exist for Linux and Windows.  sqlite.dll on Windows 
+       and sqlite.so on Linux.  The source code is available too.</li>
+
        <li>Exists in namespace and assembly Mono.Data.SqliteClient</li>
        
-       <li>Created by Vladimir Vukicevic</li>
-       
-       <li><a href"http://www.hwaci.com/sw/sqlite/download.html">SQL Lite</a>
-       binaries exist for Linux and Windows.  sqlite.dll on Windows 
-       and sqlite.so on Linux.</li>
+       <li>Created by Vladimir Vukicevic so he could have a database of
+       thumbnail images for mPhoto.  mPhoto is GUI application 
+       for cataloging images.  mPhoto runs on Mono 
+       and uses <a href="http://www.go-mono.com/gtk-sharp.html">GTK#</a> for its GUI.</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
@@ -32,14 +57,19 @@
 
 <ul>
        <li>Have a working mcs and mono</li>
+       
        <li>Make sure Mono.Data.SqliteClient.dll was built and is installed
        in the same place as the mono class libraries.</li>
+       
        <li>If you do not have <a href"http://www.hwaci.com/sw/sqlite/download.html">SQL Lite</a>,
        download it.  There are binaries for Windows and Linux.</li>
+       
        <li>There is a test named SqliteTest.cs found at mcs/class/Mono.Data.SqliteTest/Test</li>
+       
        <li>Has a connection string format of "URI=file:some/path".  For example, 
        the connection string "URI=file:SqliteTest.db" will use the database file 
        named SqliteTest.db, if it does not exist, the file will be created.</li>
+       
        <li>C# Example:
 <pre>
  using System;
@@ -52,7 +82,8 @@
     {
        string connectionString = "URI=file:SqliteTest.db";
        IDbConnection dbcon;
-       dbcon = new MySQLConnection(connectionString);
+       dbcon = new SqliteConnection(connectionString);
+       dbcon.Open();
        IDbCommand dbcmd = dbcon.CreateCommand();
        // requires a table to be created named employee
        // with columns firstname and lastname
@@ -63,11 +94,11 @@
        string sql = 
           "SELECT firstname, lastname " + 
           "FROM employee";
-       dbcmd.ConnectionString = sql;
+       dbcmd.CommandText = sql;
        IDataReader reader = dbcmd.ExecuteReader();
        while(reader.Read()) {
-            string FirstName = reader[0];
-            string LastName = reader[1];
+            string FirstName = (string) reader[0];
+            string LastName = (string) reader[1];
             Console.WriteLine("Name: " + 
                 FirstName + " " + LastName);
        }