diff options
author | Daniel Morgan <monodanmorg@yahoo.com> | 2002-05-06 03:23:48 +0400 |
---|---|---|
committer | Daniel Morgan <monodanmorg@yahoo.com> | 2002-05-06 03:23:48 +0400 |
commit | 506ccff8d59db68b1b5f04bd928d895f5c520bd7 (patch) | |
tree | 50fbe03072bd1b265a7413cb513f5b482bf5e02e /web/ado-net | |
parent | 258e58513efc1852aa0a06d2c16d044334262db4 (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-net | 22 |
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> |