| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- * 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>
|