diff options
author | Daniel Morgan <monodanmorg@yahoo.com> | 2003-02-17 18:03:43 +0300 |
---|---|---|
committer | Daniel Morgan <monodanmorg@yahoo.com> | 2003-02-17 18:03:43 +0300 |
commit | 192ac46f0a95908428901bf0bc9d66e47c72a1df (patch) | |
tree | a4d32171d67ea7de6eeb56c420131f2337e651e3 /web/sqlite | |
parent | f369737334b5d047ca5702e819b56b6b18c689c3 (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-x | web/sqlite | 41 |
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 |