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

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>