X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=web%2Fmysql;h=2449bc1f4e75b90e95c632205e06b28339a6f636;hb=e9d9e938eaba9b500cc322334aa2688bac01f6a9;hp=23a83129117c0dd3bb664828c0aec4fcae4e0835;hpb=af653b483b9bf8247c85ec0fcfa984e082d1718d;p=mono.git

diff --git a/web/mysql b/web/mysql
index 23a83129117..2449bc1f4e7 100755
--- a/web/mysql
+++ b/web/mysql
@@ -14,30 +14,23 @@
 		</ul>
 	</li>
 
-	<li>Mono.Data.MySql (deprecated)
+	<li>Mono.Data.MySql (DEPRECATED)
 		<ul>
-			<li>Deprecated in favor of ByteFX.Data.MySQLClient
-		
-			<li>Written in C# and uses
-				the MySQL C Client Library</li>
-
-			<li>Exists in namespace Mono.Data.MySql and assembly Mono.Data.MySql</li>
-	
-			<li>Works on Windows and Linux via the MySQL client shared library
-				(libmySQL.dll on Windows and libmysqlclient.so on Linux).</li>
-	    
-			<li>Started by Daniel Morgan using 
-				<a href="http://www.cybercom.net/~zbrad/DotNet/MySql/">C# Bindings to MySQL</a> from <a href="mailto:zbrad@cybercom.net">Brad Merill</a></li>
+			<li>Deprecated in favor of ByteFX.Data.MySQLClient.  Mono.Data.MySql is no longer included in
+			Mono releases.</li>
 		</ul>
 	</li>
 	
+	<li>Bugs with Mono or the data provider should be reported 
+	in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>.  If you
+	do not have Bugzilla user account, it is free 
+	and easy to 
+	create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
+	
 </ul>
 
  <p><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>
-
- <p>Testing for Mono's Mono.Data.MySql and ByteFX's ByteFX.Data.MySQLClient is below.
+ in the Microsoft .NET Environment</a> is a nice article to read.</li>
     
 ** Current Status
 
@@ -45,7 +38,7 @@
 
 <ul>
 
-	<li>ByteFX.Data.MySQLClient
+	<li>ByteFX.Data.MySqlClient
 		<ul>
 			<li>Build and Runs on Microsoft .NET and Mono</li>
 			<li>Works with SQL# (command-line and GTK# GUI versions)</li>
@@ -67,31 +60,7 @@
 		</ul>
 	</li>
 	
-	<li>Mono.Data.MySql (deprecated)
-		<ul>
-			<li>can connect</li>
-	
-			<li>can execute non-queries via ExecuteNonQuery()</li>
-	
-			<li>can execute aggregates via ExecuteScalar() and retrieve the
-				single row/single column result</li>
-	
-			<li>can execute queries and retrieve results using a data reader.</li>
-	
-			<li>a schema DataTable has been partially 
-				implemented which is returned from GetSchemaTable() in MySqlDataReader.</li>
-	
-			<li>a DataTable in a DataSet can be filled via a MySqlDataAdapter</li>
-		
-			<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.</li>
-	
-			<li>Works in the SQL# command-line and GTK# GUI version</li>
-		</ul>
+	<li>Mono.Data.MySql (DEPRECATED)
 	</li>
 	
 </ul>
@@ -101,7 +70,7 @@
  The current plan for the MySQL data providers:
  
  <ul>
-	<li>ByteFX.Data.MySQLClient
+	<li>ByteFX.Data.MySqlClient
 		<ul>
 			<li>Testing and fixes</li>
 			<li>Implement missing features</li>
@@ -115,13 +84,7 @@
 			features all of MySQLClient to work on Mono</li>
 		</ul>
 	</li>
-	<li>Mono.Data.MySql (deprecated)
-		<ul>
-			<li>Testing and bug fixes</li>
-			<li>Mono.Data.MySql is deprecated and therefore maybe removed
-			at a later date.  It will stay in Mono for now because other
-			programs maybe using it now.</li>
-		</ul>
+	<li>Mono.Data.MySql (DEPRECATED)
 	</li>
 </ul>
 
@@ -155,7 +118,7 @@
 <pre>
  using System;
  using System.Data;
- using ByteFX.Data.MySQLClient;
+ using ByteFX.Data.MySqlClient;
  
  public class Test 
  {
@@ -167,7 +130,8 @@
           "User ID=myuserid;" +
           "Password=mypassword;";
        IDbConnection dbcon;
-       dbcon = new MySQLConnection(connectionString);
+       dbcon = new MySqlConnection(connectionString);
+       dbcon.Open();
        IDbCommand dbcmd = dbcon.CreateCommand();
        // requires a table to be created named employee
        // with columns firstname and lastname
@@ -181,8 +145,8 @@
        dbcmd.CommandText = sql;
        IDataReader reader = dbcmd.ExecuteReader();
        while(reader.Read()) {
-            string FirstName = reader["firstname"];
-            string LastName = reader["lastname"];
+            string FirstName = (string) reader["firstname"];
+            string LastName = (string) reader["lastname"];
             Console.WriteLine("Name: " + 
                   FirstName + " " + LastName);
        }
@@ -200,18 +164,9 @@
 	<li>Building C# Example:
 	<ul>
 		<li>Save the example to a file, such as, TestExample.cs</li>
-		<li>Build on Linux:
 <pre>
 	mcs TestExample.cs -r System.Data.dll \
 	    -r ByteFX.Data.dll
-</pre>
-		</li>
-		<li>Build on Windows via Cygwin:
-<pre>
-	mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
-	     TestExample.cs \
-	     -lib:C:/cygwin/home/MyHome/mono/install/lib \
-	     -r System.Data.dll -r ByteFX.Data.dll
 </pre>
 		</li>
 	</ul>
@@ -224,102 +179,3 @@ mono TestExample.exe
 
 </ul>
 
-** Testing for Mono's MySQL provider (Mono.Data.MySql)
-
-<ul>
-	<li>Have access to a MySQL database or download it from
-		<ul>
-			<li><a href="http://www.mysql.com/downloads/index.html">MySQL AB</a></li>
-		</ul>
-	</li>
-	
-	<li>Take a look at MySqlTest.cs in mcs/class/Mono.Data.MySql/Test</li>
-	<li>On Linux, you may need to make a symbolic link from libmySQL.dll to libmysqlclient.dll</li>
-	
-	<li>Has a ConnectionString format: 
-<pre>
- "Server=hostname;" +
- "Database=database;" +
- "User ID=username;" +
- "Password=password"
-         (or)
- "host=hostname;" +
- "dbname=database;" +
- "user=username;" +
- "passwd=password"
-</pre>
-
-	<li>C# Example:
-<pre>
- using System;
- using System.Data;
- using Mono.Data.MySql;
- 
- public class Test 
- {
-    public static void Main(string[] args)
-    {
-       string connectionString = 
-          "Server=localhost;" +
-          "Database=test;" +
-          "User ID=myuserid;" +
-          "Password=mypassword;";
-       IDbConnection dbcon;
-       dbcon = new MySqlConnection(connectionString);
-       IDbCommand dbcmd = dbcon.CreateCommand();
-       // requires a table to be created named employee
-       // with columns firstname and lastname
-       // such as,
-       //        CREATE TABLE employee (
-       //           firstname varchar(32),
-       //           lastname varchar(32));
-       string sql = 
-            "SELECT firstname, lastname " + 
-            "FROM employee";
-       dbcmd.CommandText = sql;
-       IDataReader reader = dbcmd.ExecuteReader();
-       while(reader.Read()) {
-            string FirstName = reader["firstname"];
-            string LastName = reader["lastname"];
-            Console.WriteLine("Name: " + 
-                 FirstName + " " + LastName);
-       }
-       // clean up
-       reader.Close();
-       reader = null;
-       dbcmd.Dispose();
-       dbcmd = null;
-       dbcon.Close();
-       dbcon = null;
-    }
- }
-</pre>
-	</li>
-	<li>Building C# Example:
-	<ul>
-		<li>Save the example to a file, such as, TestExample.cs</li>
-		<li>Build on Linux:
-<pre>
-	mcs TestExample.cs \
-	    -r System.Data.dll \
-	    -r Mono.Data.MySql.dll
-</pre>
-		</li>
-		<li>Build on Windows via Cygwin:
-<pre>
-	mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
-	     TestExample.cs \
-	     -lib:C:/cygwin/home/MyHome/mono/install/lib \
-	     -r System.Data.dll \
-	     -r Mono.Data.MySql.dll
-</pre>
-		</li>
-	</ul>
-	</li>
-	<li>Running the Example:
-<pre>
-mono TestExample.exe
-</pre>
-	</li>
-
-</ul>