2
0

tdsclient 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. * TDS Generic Provider
  2. <ul>
  3. <li>ADO.NET Provider for older Sybase and Microsoft SQL Server databases
  4. <li>Exists in namespace Mono.Data.TdsClient and assembly Mono.Data.TdsClient
  5. <li>Created by Tim Coleman
  6. <li>Used the <a href="http://www.freetds.org/">FreeTDS</a> and
  7. <a href="http://jtds.sourceforge.net/">jTDS</a> projects as resources.
  8. <li>Implemented in 100% C#
  9. <li>Is similar to the Mono.Data.SybaseClient and System.Data.SqlClient providers.
  10. <li>Uses TDS Protocol Version 4.2 by default
  11. <li><a href="http://www.go-mono.com/tds-providers.html">Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono</a>
  12. </ul>
  13. * Current Status
  14. <ul>
  15. <li>Only builds on Windows currently due to mcs does not support modules and mcs
  16. has problems with code that is internal.
  17. <li>Able to connect to Microsoft SQL Server and Sybase databases
  18. <li>SQL commands can be executed
  19. via ExecuteNonQuery() of a TdsCommand.
  20. <li>SQL aggregates can be executed and a single row and single column
  21. result can be retrieved via ExecuteScalar() of a TdsCommand
  22. <li>SQL queries can be executed via ExecuteReader() and results
  23. can be retrieved via TdsDataReader.
  24. <li>a DataTable with schema info about a result can be gotten via GetSchemaTable()
  25. in a TdsDataReader
  26. <li>Data can be filled in a DataTable in a DataSet via a TdsDataAdapter
  27. </ul>
  28. * Action plan
  29. <ul>
  30. <li>Connection timeouts is being developed now.
  31. <li>TODO
  32. </ul>