mysql 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. * MySQL Data Provider
  2. <ul>
  3. <li>MySQL Data Provider for
  4. <a href="http://www.mysql.com/">MySQL</a> databases. It is written in C# and uses
  5. the MySQL C Client Library
  6. <li>Exists in namespace Mono.Data.MySql and assembly Mono.Data.MySql
  7. <li>Works on Windows and Linux via the MySQL client shared library
  8. (libmySQL.dll on Windows and libmysqlclient.so on Linux).
  9. <li>Started by Daniel Morgan using C# Bindings to MySQL from Brad Meril.
  10. <li><a href="http://www.mysql.com/articles/dotnet/">Exploring MySQL in the Microsoft .NET Environment</a> is an article
  11. by Mr. Venu who is a MySQL AB developer.
  12. <li>Other projects which have created a .NET Data provider for MySQL in C#
  13. <ul>
  14. <li><a href="http://sourceforge.net/projects/mysqldrivercs/">MySQLDriverCS</a> is a MySQL provider written in C#
  15. <li><a href="http://sourceforge.net/projects/mysqlnet/">MySQLNet</a> is a MySQL Manager provider written in C#
  16. </ul>
  17. </ul>
  18. * Current Status
  19. <ul>
  20. <li>can connect
  21. <li>can execute non-queries via ExecuteNonQuery()
  22. <li>can execute aggregates via ExecuteScalar() and retrieve the
  23. single row/single column result
  24. <li>can execute queries and retrieve results using a data reader.
  25. <li>a schema DataTable has been partially
  26. implemented which is returned from GetSchemaTable() in MySqlDataReader.
  27. <li>a DataTable in a DataSet can be filled via a MySqlDataAdapter
  28. <li>The shared client libraries
  29. between windows version and linux are different: windows has libmySQL.dll
  30. while linux has libmysqlclient.so. This is handled by the
  31. file etc/mono/config which is mapped by the mono runtime in knowing
  32. which native shared library to load. In cvs, this file is mono/config.in and
  33. can be modified with a text editor.
  34. </ul>
  35. * Action plan
  36. The current plan to work on the MySQL data provider:
  37. <ul>
  38. <li>Parameters support via MySqlParameter and MySqlParameterCollection
  39. <li>Support LOBs (Large Object)
  40. <li>Change the MySQL provider to not be dependent on a client library and
  41. be written in 100% C#
  42. <li>Connection pooling
  43. <li>Get the provider to work like other data providers
  44. </ul>