sqlclient 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. * Microsoft SQL Server Provider
  2. <ul>
  3. <li>ADO.NET Provider for Microsoft SQL Server 7/2000 databases
  4. <li>Exists in namespace System.Data.SqlClient and assembly System.Data
  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.TdsClient and Mono.Data.SybaseClient providers.
  10. </ul>
  11. * Current Status
  12. <ul>
  13. <li>Able to connect to Microsoft SQL Server 7/2000 databases
  14. <li>Connection pooling works.
  15. <li>Stored Procedures work
  16. <li>Parameters work.
  17. <li>Prepare works.
  18. <li>SQL commands can be executed
  19. via ExecuteNonQuery() of a SqlCommand.
  20. <li>SQL aggregates can be executed and a single row and single column
  21. result can be retrieved via ExecuteScalar() of a SqlCommand
  22. <li>SQL queries can be executed via ExecuteReader() and results
  23. can be retrieved via SqlDataReader.
  24. <li>a DataTable with schema info about a result can be gotten via GetSchemaTable()
  25. in a SqlDataReader
  26. <li>XML can be read via ExecuteXmlReader in a SqlCommand.
  27. <li>Data can be filled in a DataTable in a DataSet via a SqlDataAdapter
  28. <li>Uses TDS Protocol Version 7.0
  29. <li><a href="http://www.go-mono.com/tds-providers.html">Design of the Microsoft SQL Server, Sybase, and TDS Providers in Mono</a>
  30. </ul>
  31. * Action plan
  32. <ul>
  33. <li>Connection timeouts is being developed now.
  34. <li>TODO
  35. </ul>