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-11-12 18:53:12 +0300
committerDaniel Morgan <monodanmorg@yahoo.com>2002-11-12 18:53:12 +0300
commit451af388d71c4393a779fd30ea01a3264084961b (patch)
treeea6b9e8822f2f73c2deae609eef6d0387b28c13a /web/sqlclient
parent358d3c04b207dd05c32cf5869a636f621db51ae3 (diff)
2002-11-12 Daniel Morgan <danmorg@sc.rr.com>
* doc/oledb * doc/odbc * doc/mysql * doc/sqlite * doc/sqlclient * doc/tdsclient * doc/sybase * doc/firebird: added web pages for each specific data provider * doc/ado-net * doc/postgresql: updated web page with current status * doc/web/commands * doc/web/makefile: updated to include svn path=/trunk/mono/; revision=8949
Diffstat (limited to 'web/sqlclient')
-rwxr-xr-xweb/sqlclient58
1 files changed, 58 insertions, 0 deletions
diff --git a/web/sqlclient b/web/sqlclient
new file mode 100755
index 00000000000..f73ba3eb4f4
--- /dev/null
+++ b/web/sqlclient
@@ -0,0 +1,58 @@
+* Microsoft SQL Server Provider
+
+<ul>
+ <li>ADO.NET Provider for Microsoft SQL Server 7/2000 databases
+
+ <li>Exists in namespace System.Data.SqlClient and assembly System.Data
+
+ <li>Created by Tim Coleman
+
+ <li>Used the <a href="http://www.freetds.org/">FreeTDS</a> and
+ <a href="http://jtds.sourceforge.net/">jTDS</a> projects as resources.
+
+ <li>Implemented in 100% C#
+
+ <li>Is similar to the Mono.Data.TdsClient and Mono.Data.SybaseClient providers.
+</ul>
+
+* Current Status
+
+<ul>
+ <li>Able to connect to Microsoft SQL Server 7/2000 databases
+
+ <li>Connection pooling works.
+
+ <li>Stored Procedures work
+
+ <li>Parameters work.
+
+ <li>Prepare works.
+
+ <li>SQL commands can be executed
+ via ExecuteNonQuery() of a SqlCommand.
+
+ <li>SQL aggregates can be executed and a single row and single column
+ result can be retrieved via ExecuteScalar() of a SqlCommand
+
+ <li>SQL queries can be executed via ExecuteReader() and results
+ can be retrieved via SqlDataReader.
+
+ <li>a DataTable with schema info about a result can be gotten via GetSchemaTable()
+ in a SqlDataReader
+
+ <li>XML can be read via ExecuteXmlReader in a SqlCommand.
+
+ <li>Data can be filled in a DataTable in a DataSet via a SqlDataAdapter
+
+ <li>Uses TDS Protocol Version 7.0
+
+ <li><a href="http://www.go-mono.com/tds-providers.html">Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono</a>
+</ul>
+
+* Action plan
+
+<ul>
+ <li>Connection timeouts is being developed now.
+
+ <li>TODO
+</ul>