Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/mono/mono.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Morgan <monodanmorg@yahoo.com>2003-02-17 18:03:43 +0300
committerDaniel Morgan <monodanmorg@yahoo.com>2003-02-17 18:03:43 +0300
commit192ac46f0a95908428901bf0bc9d66e47c72a1df (patch)
treea4d32171d67ea7de6eeb56c420131f2337e651e3 /web/sqlite
parentf369737334b5d047ca5702e819b56b6b18c689c3 (diff)
2003-02-17 Daniel Morgan <danmorg@sc.rr.com>
* doc/provider-factory: add new web page about Mono.Data's ProviderFactory * doc/web/commands * doc/web/makefile: add provider-factory web page to build * doc/ado-net * doc/ibmdb2 * doc/postgresql * doc/sqlclient * doc/tdsclient * doc/sybase * doc/mysql * doc/firebird * doc/oracle * doc/oledb * doc/odbc * doc/sqlite: updated web pages svn path=/trunk/mono/; revision=11639
Diffstat (limited to 'web/sqlite')
-rwxr-xr-xweb/sqlite41
1 files changed, 36 insertions, 5 deletions
diff --git a/web/sqlite b/web/sqlite
index 1cba0bed564..5952bbfe789 100755
--- 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
+ implements an embeddable SQL database engine. Programs that link with
+ the SQLite library can have SQL database access without
+ running a separate RDBMS process. The distribution
+ comes with a standalone command-line access program (sqlite) that
+ can be used to administer an SQLite database and which serves
+ as an example of how to use the SQLite library. SQLite is not a client library
+ used to connect to a big database server. SQLite is the server. The SQLite
+ library reads and writes directly to and from the database files on disk.</li>
+
+ <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;
@@ -53,6 +83,7 @@
string connectionString = "URI=file:SqliteTest.db";
IDbConnection dbcon;
dbcon = new MySQLConnection(connectionString);
+ dbcon.Open();
IDbCommand dbcmd = dbcon.CreateCommand();
// requires a table to be created named employee
// with columns firstname and lastname