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:
authorGonzalo Paniagua Javier <gonzalo.mono@gmail.com>2010-10-22 20:52:19 +0400
committerGonzalo Paniagua Javier <gonzalo.mono@gmail.com>2010-10-22 20:52:19 +0400
commitf8c9c8751290f47fa17fa5851ce97ddc9c443bf4 (patch)
tree46e4a8bc6c0a3996df0f0c78753519ebcc93572d /web/sqlite
parent231527ee6286af554c59396037c8504a6564395e (diff)
Sniff, sniff
Remove the old (really) stuff to generate the website from makefiles.
Diffstat (limited to 'web/sqlite')
-rwxr-xr-xweb/sqlite143
1 files changed, 0 insertions, 143 deletions
diff --git a/web/sqlite b/web/sqlite
deleted file mode 100755
index 88a2f99d60b..00000000000
--- a/web/sqlite
+++ /dev/null
@@ -1,143 +0,0 @@
-* 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 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
-
-<ul>
- <li>Able to connect, execute commands, and retrieve data...</li>
-
- <li>Works in mPhoto by providing access to a SQL Lite database to store images.</li>
-</ul>
-
-** Action Plan
-
-<ul>
- <li>Create a DataAdapter for SQL Lite named SqliteDataAdapter that can be used to
- Fill a DataTable in a DataSet</li>
-
- <li>Get the method GetSchemaTable() in class SqliteDataReader to return a DataTable
- that works</li>
-</ul>
-
-** Testing
-
-<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;
- using System.Data;
- using Mono.Data.SqliteClient;
-
- public class Test
- {
- public static void Main(string[] args)
- {
- string connectionString = "URI=file:SqliteTest.db";
- IDbConnection dbcon;
- dbcon = new SqliteConnection(connectionString);
- dbcon.Open();
- IDbCommand dbcmd = dbcon.CreateCommand();
- // requires a table to be created named employee
- // with columns firstname and lastname
- // such as,
- // CREATE TABLE employee (
- // firstname varchar(32),
- // lastname varchar(32));
- string sql =
- "SELECT firstname, lastname " +
- "FROM employee";
- dbcmd.CommandText = sql;
- IDataReader reader = dbcmd.ExecuteReader();
- while(reader.Read()) {
- string FirstName = (string) reader[0];
- string LastName = (string) reader[1];
- Console.WriteLine("Name: " +
- FirstName + " " + LastName);
- }
- // 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 Mono.Data.SqliteClient.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 Mono.Data.SqliteClient.dll
-</pre>
- </li>
- </ul>
- </li>
- <li>Running the Example:
-<pre>
-mono TestExample.exe
-</pre>
- </li>
-
-</ul>
-