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>2002-05-06 03:23:48 +0400
committerDaniel Morgan <monodanmorg@yahoo.com>2002-05-06 03:23:48 +0400
commit506ccff8d59db68b1b5f04bd928d895f5c520bd7 (patch)
tree50fbe03072bd1b265a7413cb513f5b482bf5e02e /web/ado-net
parent258e58513efc1852aa0a06d2c16d044334262db4 (diff)
2002-05-05 Daniel Morgan <danmorg@sc.rr.com>
* doc/ado-net: updated the current status which I kept forgetting to do. svn path=/trunk/mono/; revision=4324
Diffstat (limited to 'web/ado-net')
-rw-r--r--web/ado-net22
1 files changed, 20 insertions, 2 deletions
diff --git a/web/ado-net b/web/ado-net
index 11162c07f24..87d2f1f86d2 100644
--- a/web/ado-net
+++ b/web/ado-net
@@ -57,8 +57,26 @@
* Current Status
- We are able now to run basic commands (INSERT, DELETE) into a
- PostgreSQL database (see mcs/class/System.Data/Test/TestSqlInsert.cs).
+ We are able to do simple CREATE TABLE, DROP TABLE, INSERT, and
+ DELETE SQL commands using the ExecuteNonQuery method in SqlCommand.
+
+ We are also able to do simple aggregate functions,
+ ie, count(), sum(), avg(), min(), and
+ max() in a simple SELECT SQL query using ExecuteSecalar() now.
+
+ We are also able to retrieve data with a simple SELECT SQL query
+ using ExecuteReader() which returns a SqlDataReader. We are able to
+ GetSchemaTable() get the meta data about the table columns. We are able
+ to Read() to get each row from the result set. We are able to get
+ String data (char, bpchar (character), text, varchar), Int16 (int2 or smallint),
+ and Int32 (int4 or integer), Int64 (int8 or bigint). More data types will
+ follow later on.
+
+ Parameters are not working nor has stored procedures been tested - but they will be.
+
+ A lot of functionality in System.Data is missing, but the infrastructure is
+ starting to come together.
+
To compile that test program, you need:
<b>On Linux</b>