Hey, For those wanting to see SQL# using the MySQL ADO.NET Provider working in Mono.
SQL# has better formatting of the output then it did before. It was buggy before. Numbers are right-justified now. DateTime is expressed in ISO format "YYYY-MM-DD HH:MM:SS". Any column longer than 32 characters is truncated to 32 characters. Here is the output of running it: DanielMorgan@DANPC ~/mono/mcs/class/System.Data/Test $ mcs SqlSharpCli.cs -r System.Data.dll Compilation succeeded DanielMorgan@DANPC ~/mono/mcs/class/System.Data/Test $ mono SqlSharpCli.exe Welcome to SQL#. The interactive SQL command-line client for Mono.Data. See http://www.go-mono.com/ for more details. Type: \Q to quit \ConnectionString to set the ConnectionString \Provider to set the Provider: {OleDb,SqlClient,MySql,Odbc, Oracle,PostgreSql,Sqlite) \Open to open the connection \Close to close the connection \Execute to execute SQL command(s)/queries(s) \h to show this help. \defaults to show default variables. The default Provider is POSTGRESQL The default ConnectionString is: "host=localhost;dbname=test;user=postgres" SQL# \provider mysql The default Provider is LOADEXTPROVIDER Assembly: Mono.Data.MySql Connection Class: Mono.Data.MySql.MySqlConnection SQL# \connectionstring dbname=test SQL# \open Attempt to open connection... Loading external provider... External provider loaded. Open was successfull. SQL# select int_value,datetime_value,text_value,double_value SQL# from mono_mysql_test SQL# \e Execute SQL: select int_value,datetime_value,text_value,double_value from mono_mysql_test Display any result sets... Display the result set 1 Fields in Query Result: 4 int_value datetime_value text_value double_value ========= =================== ========== ============ 777 2002-12-31 11:15:07 smell 2.2 4 2002-12-31 11:15:07 smell 2.2 94 2003-11-23 10:24:45 nope 92.2 Rows retrieved: 3 SQL# _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
