* TDS Generic Provider
- ADO.NET Provider for older Sybase and Microsoft SQL Server databases
- Exists in namespace Mono.Data.TdsClient and assembly Mono.Data.TdsClient
- Created by Tim Coleman
- Used the FreeTDS and
jTDS projects as resources.
- Implemented in 100% C#
- Is similar to the Mono.Data.SybaseClient and System.Data.SqlClient providers.
- Uses TDS Protocol Version 4.2 by default
- Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono
* Current Status
- Only builds on Windows currently due to mcs does not support modules and mcs
has problems with code that is internal.
- Able to connect to Microsoft SQL Server and Sybase databases
- SQL commands can be executed
via ExecuteNonQuery() of a TdsCommand.
- SQL aggregates can be executed and a single row and single column
result can be retrieved via ExecuteScalar() of a TdsCommand
- SQL queries can be executed via ExecuteReader() and results
can be retrieved via TdsDataReader.
- a DataTable with schema info about a result can be gotten via GetSchemaTable()
in a TdsDataReader
- Data can be filled in a DataTable in a DataSet via a TdsDataAdapter
* Action plan
- Connection timeouts is being developed now.
- TODO