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