diff options
author | Daniel Morgan <monodanmorg@yahoo.com> | 2002-11-12 18:53:12 +0300 |
---|---|---|
committer | Daniel Morgan <monodanmorg@yahoo.com> | 2002-11-12 18:53:12 +0300 |
commit | 451af388d71c4393a779fd30ea01a3264084961b (patch) | |
tree | ea6b9e8822f2f73c2deae609eef6d0387b28c13a /web/sqlclient | |
parent | 358d3c04b207dd05c32cf5869a636f621db51ae3 (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-x | web/sqlclient | 58 |
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> |