* Microsoft SQL Server Provider
- ADO.NET Provider for Microsoft SQL Server 7/2000 databases
- Exists in namespace System.Data.SqlClient and assembly System.Data
- Created by Tim Coleman
- Used the FreeTDS and
jTDS projects as resources.
- Implemented in 100% C#
- Is similar to the Mono.Data.TdsClient and Mono.Data.SybaseClient providers.
* Current Status
- Able to connect to Microsoft SQL Server 7/2000 databases
- Connection pooling works.
- Stored Procedures work
- Parameters work.
- Prepare works.
- SQL commands can be executed
via ExecuteNonQuery() of a SqlCommand.
- SQL aggregates can be executed and a single row and single column
result can be retrieved via ExecuteScalar() of a SqlCommand
- SQL queries can be executed via ExecuteReader() and results
can be retrieved via SqlDataReader.
- a DataTable with schema info about a result can be gotten via GetSchemaTable()
in a SqlDataReader
- XML can be read via ExecuteXmlReader in a SqlCommand.
- Data can be filled in a DataTable in a DataSet via a SqlDataAdapter
- Uses TDS Protocol Version 7.0
- Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono
* Action plan
- Connection timeouts is being developed now.
- TODO