diff options
author | Daniel Morgan <monodanmorg@yahoo.com> | 2002-11-12 18:53:12 +0300 |
---|---|---|
committer | Daniel Morgan <monodanmorg@yahoo.com> | 2002-11-12 18:53:12 +0300 |
commit | 451af388d71c4393a779fd30ea01a3264084961b (patch) | |
tree | ea6b9e8822f2f73c2deae609eef6d0387b28c13a /web/mysql | |
parent | 358d3c04b207dd05c32cf5869a636f621db51ae3 (diff) |
2002-11-12 Daniel Morgan <danmorg@sc.rr.com>
* doc/oledb
* doc/odbc
* doc/mysql
* doc/sqlite
* doc/sqlclient
* doc/tdsclient
* doc/sybase
* doc/firebird: added web pages
for each specific data provider
* doc/ado-net
* doc/postgresql: updated web page
with current status
* doc/web/commands
* doc/web/makefile: updated to include
svn path=/trunk/mono/; revision=8949
Diffstat (limited to 'web/mysql')
-rwxr-xr-x | web/mysql | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/web/mysql b/web/mysql new file mode 100755 index 00000000000..b8c96d973d3 --- /dev/null +++ b/web/mysql @@ -0,0 +1,66 @@ +* MySQL Data Provider + +<ul> + <li>MySQL Data Provider for + <a href="http://www.mysql.com/">MySQL</a> databases. It is written in C# and uses + the MySQL C Client Library + + <li>Exists in namespace Mono.Data.MySql and assembly Mono.Data.MySql + + <li>Works on Windows and Linux via the MySQL client shared library + (libmySQL.dll on Windows and libmysqlclient.so on Linux). + + <li>Started by Daniel Morgan using C# Bindings to MySQL from Brad Meril. + + <li><a href="http://www.mysql.com/articles/dotnet/">Exploring MySQL in the Microsoft .NET Environment</a> is an article + by Mr. Venu who is a MySQL AB developer. + + <li>Other projects which have created a .NET Data provider for MySQL in C# + <ul> + <li><a href="http://sourceforge.net/projects/mysqldrivercs/">MySQLDriverCS</a> is a MySQL provider written in C# + <li><a href="http://sourceforge.net/projects/mysqlnet/">MySQLNet</a> is a MySQL Manager provider written in C# + + </ul> +</ul> + +* Current Status + +<ul> + <li>can connect + + <li>can execute non-queries via ExecuteNonQuery() + + <li>can execute aggregates via ExecuteScalar() and retrieve the + single row/single column result + + <li>can execute queries and retrieve results using a data reader. + + <li>a schema DataTable has been partially + implemented which is returned from GetSchemaTable() in MySqlDataReader. + + <li>a DataTable in a DataSet can be filled via a MySqlDataAdapter + + <li>The shared client libraries + between windows version and linux are different: windows has libmySQL.dll + while linux has libmysqlclient.so. This is handled by the + file etc/mono/config which is mapped by the mono runtime in knowing + which native shared library to load. In cvs, this file is mono/config.in and + can be modified with a text editor. +</ul> + +* Action plan + +The current plan to work on the MySQL data provider: + + <ul> + <li>Parameters support via MySqlParameter and MySqlParameterCollection + + <li>Support LOBs (Large Object) + + <li>Change the MySQL provider to not be dependent on a client library and + be written in 100% C# + + <li>Connection pooling + + <li>Get the provider to work like other data providers + </ul> |