1 * Microsoft SQL Server Provider
4 <li>ADO.NET Provider for Microsoft SQL Server 7/2000 databases
6 <li>Exists in namespace System.Data.SqlClient and assembly System.Data
8 <li>Created by Tim Coleman
10 <li>Used the <a href="http://www.freetds.org/">FreeTDS</a> and
11 <a href="http://jtds.sourceforge.net/">jTDS</a> projects as resources.
13 <li>Implemented in 100% C#
15 <li>Is similar to the Mono.Data.TdsClient and Mono.Data.SybaseClient providers.
21 <li>Able to connect to Microsoft SQL Server 7/2000 databases
23 <li>Connection pooling works.
25 <li>Stored Procedures work
31 <li>SQL commands can be executed
32 via ExecuteNonQuery() of a SqlCommand.
34 <li>SQL aggregates can be executed and a single row and single column
35 result can be retrieved via ExecuteScalar() of a SqlCommand
37 <li>SQL queries can be executed via ExecuteReader() and results
38 can be retrieved via SqlDataReader.
40 <li>a DataTable with schema info about a result can be gotten via GetSchemaTable()
43 <li>XML can be read via ExecuteXmlReader in a SqlCommand.
45 <li>Data can be filled in a DataTable in a DataSet via a SqlDataAdapter
47 <li>Uses TDS Protocol Version 7.0
49 <li><a href="http://www.go-mono.com/tds-providers.html">Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono</a>
55 <li>Connection timeouts is being developed now.