diff options
author | Daniel Morgan <monodanmorg@yahoo.com> | 2003-11-03 09:27:02 +0300 |
---|---|---|
committer | Daniel Morgan <monodanmorg@yahoo.com> | 2003-11-03 09:27:02 +0300 |
commit | 3570fe498f7ebabafe6baf6e26e2a035d1df0d54 (patch) | |
tree | 88707c21002e142b88944815e202ba15ef3a4e5c | |
parent | 3d7ed7612d1bd5e05d566821ff53b1fe1217a2f7 (diff) |
update ADO.NET and provider web pages
svn path=/trunk/mono/; revision=19568
-rw-r--r-- | doc/ado-net | 139 | ||||
-rwxr-xr-x | doc/mysql | 4 | ||||
-rwxr-xr-x | doc/odbc | 4 | ||||
-rwxr-xr-x | doc/oledb | 4 | ||||
-rwxr-xr-x | doc/oracle | 25 | ||||
-rw-r--r-- | doc/postgresql | 32 | ||||
-rwxr-xr-x | doc/sqlclient | 4 | ||||
-rwxr-xr-x | doc/sqlite | 4 | ||||
-rwxr-xr-x | doc/sybase | 4 | ||||
-rwxr-xr-x | doc/tdsclient | 4 | ||||
-rw-r--r-- | web/ado-net | 139 | ||||
-rwxr-xr-x | web/mysql | 4 | ||||
-rwxr-xr-x | web/odbc | 4 | ||||
-rwxr-xr-x | web/oledb | 4 | ||||
-rwxr-xr-x | web/oracle | 25 | ||||
-rw-r--r-- | web/postgresql | 32 | ||||
-rwxr-xr-x | web/sqlclient | 4 | ||||
-rwxr-xr-x | web/sqlite | 4 | ||||
-rwxr-xr-x | web/sybase | 4 | ||||
-rwxr-xr-x | web/tdsclient | 4 |
20 files changed, 172 insertions, 276 deletions
diff --git a/doc/ado-net b/doc/ado-net index ee9d633cbd8..c78b62edfd1 100644 --- a/doc/ado-net +++ b/doc/ado-net @@ -1,82 +1,22 @@ * ADO.NET -<p>Mono's ADO.NET Developers: - -<table border=1> - -<tr> - <td><b>Developer</b></td> - <td><b>Email</b></td> - <td><b>Contribution</b></td> -</tr> - -<tr> - <td>Rodrigo Moya</td> - <td>rodrigo -AT-<br> ximian.comNOSPAM</td> - <td>ADO.NET coordinator,<br> OLE DB provider,<br> and tests</td> -</tr> - -<tr> - <td>Daniel Morgan</td> - <td>danielmorgan -AT-<br> verizon.netNOSPAM</td> - <td>System.Data, SQL# Query Tool, MySQL, PostgreSQL, <br>Oracle providers,<br> and tests</td> -</tr> - -<tr> - <td>Tim Coleman</td> - <td>tim -AT- <br>timcoleman.comNOSPAM</td> - <td>Microsoft SQL Server, <br>Sybase, <br>TDS providers,<br> Oracle, - <br>and tests.<br> - He has - contributed <br>to other parts <br>of Mono too, <br>such as, - <br>EnterpriseServices, - XML, <br>and WebServices.</td> -</tr> - -<tr> - <td>Brian Ritchie</td> - <td>brianlritchie -AT-<br> hotmail.comNOSPAM</td> - <td>ODBC provider <br>and the ProviderFactory <br>in Mono.Data</td> -</tr> - -<tr> - <td>Vladimir Vukicevic</td> - <td>vladimir -AT-<br> pobox.comNOSPAM</td> - <td>SQL Lite provider. <br> He has contributed to GTK# <br>and mPhoto too.</td> -</tr> - -<tr> - <td>Christopher Bockner</td> - <td>cleared -AT-<br> rogers.comNOSPAM</td> - <td>IBM DB2 Universal <br>Database provider</td> -</tr> - -<tr> - <td>Ville Palo</td> - <td>vi64pa -AT-<br> koti.soon.fiNOSPAM</td> - <td>XML stuff <br>in System.Data <br>including DataSet <br> - and XmlDataDocument, <br>and tests</td> -</tr> - -<tr> - <td>Gonzalo Paniagua Javier</td> - <td>gonzalo -AT-<br> ximian.comNOSPAM</td> - <td>Integration between <br>System.Web and <br>System.Data</td> -</tr> - -<tr> - <td>Gaurav Vaish</td> - <td>gvaish -AT-<br> iitk.ac.inNOSPAM</td> - <td>Web controls</td> -</tr> - -<tr> - <td>Phillip Jerkins</td> - <td>Phillip.Jerkins -AT-<br> morgankeegan.comNOSPAM</td> - <td>Named Instance support <br>in System.Data.SqlClient</td> -</tr> - -</table> +** Data Access in Mono + +<ul> + <li>Today, our goal is to be compatible with .NET 1.0 and .NET 1.1. We also would like + to extend data access beyond what is included with .NET 1.0 and .NET 1.1, + such as, including access to more databases, such as, PostgreSQL and MySQL, + but also provide classes that help in creating data source-agnostic code, such as, Mono.Data.ProviderFactory.</li> + <li>In the future, we would like to be compatible with .NET 1.2. This + would include features like: + <ul> + <li><a href="http://longhorn.msdn.microsoft.com/lhsdk/ndp/daconworkingwithobjectspacesarchitecture.aspx">ObjectSpaces</a></li> + <li>provide support for hosting Mono languages (C-Sharp, MonoBASIC, etc...) + within a DBMS engine, such as, MySQL or PostgreSQL.</li> + <li>implement .net 1.2 classes, such as, those found in System.Data.ProviderBase</li> + <li>other stuff which can be brought up on the mono-list</li> + </ul></li> +</ul> ** Bugs and Feature Requests @@ -88,14 +28,14 @@ and easy to create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li> - <li>Any RFE (Request For Enhancement) for features missing or new functionality - should be entered as a bug in Bugzilla too</li> + <li>Any requests for new features or missing functionality + can entered as a bug in Bugzilla too</li> </ul> ** ADO.NET Data Providers -<p>List of ADO.NET Data Providers working in Mono: +<p>Mono has many ADO.NET Data Providers to get you connected: <ul> <li><a href="http://www.go-mono.com/ibmdb2.html">IBM DB2 Universal Database</a></li> @@ -147,39 +87,38 @@ <p>Some tools that can be used for ADO.NET and other technologies (ASP.NET, XML, etc). <ul> - <li><b>SQL# CLI</b> - a SQL query tool with a command-line interface. - It can be used to enter and execute SQL statements or - execute a batch of SQL commands from a file. It can + <li><p><b>SQL# command line query tool</b> is a command-line tool to + enter and execute SQL statements or + execute a batch of SQL commands from a file. + <p>It can be used to test connection strings, connect to various ADO.NET - providers, save output to text, html, or xml. It is a work-in-progress. - The SQL# CLI is distributed with the + providers, save output to text, html, or xml. + <p>The SQL# CLI is distributed with the Mono runtime and class libraries as an executable assembly sqlsharp.exe. - The source to SQL# CLI can be found in the mcs source at + <p>The source to SQL# CLI can be found in the mcs source at mcs/tools/SqlSharp/SqlSharpCli.cs </li> - <li><p><b>SQL# GUI - a graphical SQL query tool</b> allows a user - to enter SQL commands in a top panel which is a text editor. It - has a toolbar and menu for various tasks, such as, executing + <li><p><b>SQL# For GTK#</b> - is a graphical SQL database query tool</b> allows a user + to enter SQL commands in a top panel which is a text editor. + <p>It has a toolbar and menu for various tasks, such as, executing SQL commands one-at-a-time or in a batch. The results would appear in a bottom panel in a grid or could be saved to a file (xml, html, csv). - Also, the bottom panel would allow logging of SQL command executed. - Currently, there is a <a href="http://go-mono.com/images/sqlsharp.png">SQL# For GTK#</a> which - provides a GUI interface using the <a href="http://gtk-sharp.sourceforge.net">Gtk#</a> toolkit. SQL# For GTK# - is a work-in-progress and can be found in the mcs source at - mcs/tools/SqlSharp/gui/gtk-sharp</li> + <p>Also, the bottom panel would allow logging of SQL command executed. + Here is a screenshot of <a href="http://go-mono.com/images/sqlsharp.png">SQL# For GTK#</a> which + provides a GUI interface using the <a href="http://gtk-sharp.sourceforge.net">Gtk#</a> toolkit. + <p>SQL# For GTK# can be found in mono cvs as sqlsharpgtk.</li> </ul> <p>Tools we would like to have, but they have not been created yet: <ul> - <li><b>XML Schema Definition tool</b> <a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpconxmlschemadefinitiontoolxsdexe.asp">xsd.exe</a> needs - to be created. Maybe this TODO item should be at the System.XML web page instead. - + <li>Mono has an <b>XML Schema Definition tool</b> (xsd.exe).</b> + <ul> <li>This tool - would work like the xsd.exe tool included with - the .NET Framework. The Xsd.exe tools has the
+ would works like the xsd.exe tool included with + the .NET Framework. The Xsd.exe tool has the
following uses:
<ul>
<li><b>XDR to XSD</b> - used to generate an XML schema from an XDR (XML Data Reduced schema) file.
@@ -330,7 +269,7 @@ Mike Kestner or Rachel Hestilov would be the best people to ask for help on GTK#. <p><b>Integration with QT#</b> has not been started. Any information on - how this can be done is appreciated. Adam Treat would be the best + how this can be done is appreciated. Marcus would be the best person to ask about QT#. <p><b>Building System.Data</b> diff --git a/doc/mysql b/doc/mysql index 7b0a4d5811b..169aae5bae3 100755 --- a/doc/mysql +++ b/doc/mysql @@ -283,8 +283,8 @@ mono TestExample.exe 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); } @@ -175,8 +175,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); } diff --git a/doc/oledb b/doc/oledb index caa032fd8bb..1dabe6244ed 100755 --- a/doc/oledb +++ b/doc/oledb @@ -109,8 +109,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); } diff --git a/doc/oracle b/doc/oracle index 921954aef0b..16188b522ab 100755 --- a/doc/oracle +++ b/doc/oracle @@ -10,7 +10,7 @@ <li>Works with Oracle 8i</li> - <li>Untested, but should work with Oracle 9i</li> + <li>May work with Oracle 9i</li> <li>Uses the Oracle CLI (Call Level Interface) which is a C library (API) for the Oracle Client software</li> @@ -19,8 +19,6 @@ <li>Created by Daniel Morgan and Tim Coleman</li> - <li>Does not support trusted connections</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 @@ -64,14 +62,12 @@ <li>Handling of various data types need to be added.</li> - <li>Data Adapter exists, and a DataSet can be filled using it. The - Data Adapter is abstract enough that it should work as expected.</li> + <li>Data Adapter exists, and a DataSet can be filled using it.</li> <li>Lots of missing functionality and bugs.</li> <li>Works with SQL# command-line and GTK# versions in cvs. Only works with - simple character data though. SQL# For GTK# can only show the results to - the TextView because the Data Adapter is not yet available</li> + simple character data though.</li> </ul> @@ -83,7 +79,8 @@ <li>transactions (WORKING)</li> <li>Stored Procedures, Functions, and Packages support</li> <li>Be able to fill a DataTable in a DataSet via a data adapter (IN PROGRESS)</li> - <li>Support for Oracle 8i and 9i (UNKNOWN)</li> + <li>Support for Oracle 8i (WORKING</li> + <li>Support for Oracle 9i (UNKNOWN)</li> <li>Support LOBs</li> <li>Support all the data types</li> <li>Implement Connection pooling</li> @@ -96,7 +93,7 @@ <ul> <li>Have a working mono and mcs</li> - <li>Have access to an Oracle 8i database or download it from + <li>Have access to an Oracle 8i or 9i database or download it from <a href="http://www.oracle.com/">Oracle</a>. If you are connecting remotely to an Oracle database, you need the Oracle client software. Registration to the <a href="http://technet.oracle.com/">Oracle Technology Network</a> is free. If installing on Linux, @@ -129,16 +126,16 @@ "Data Source=testdb;" + "User ID=scott;" + "Password=tiger;"; - IDbConnection dbcon; + OracleConnection dbcon = null; dbcon = new OracleConnection (connectionString); dbcon.Open (); - IDbCommand dbcmd = dbcon.CreateCommand (); + OracleCommand dbcmd = dbcon.CreateCommand (); string sql = "SELECT ename, job FROM scott.emp"; dbcmd.CommandText = sql; - IDataReader reader = dbcmd.ExecuteReader (); + OracleDataReader reader = dbcmd.ExecuteReader (); while (reader.Read ()) { - string employeeName = reader["ename"]; - string job = reader["job"]; + string employeeName = (string) reader["ename"]; + string job = (string) reader["job"]; Console.WriteLine ("Employee Name: {0} Job: {1}", employeeName, job); } diff --git a/doc/postgresql b/doc/postgresql index 6e9643af234..6e5bb4f2483 100644 --- a/doc/postgresql +++ b/doc/postgresql @@ -1,10 +1,10 @@ * PostgreSQL and Mono When it comes to Mono and PostgreSQL, there are many ways - you can handle your data. You have Data Providers which can be used - to retrieve or manipulate data from a remote application written for Mono. - Then you have the ability to host Mono within PostgreSQL to - have the applications run on the server which makes things faster. + you can handle your data. You have many Mono Data Providers which can be used + to access data from a application written for Mono. + Then there is the future goal of having the ability to host Mono within PostgreSQL to + have the applications run on the server which makes things much faster. * Hosting Mono in PostgreSQL @@ -14,13 +14,17 @@ * Data Providers - There are two ADO.NET data providers for <a href="http://www.postgresql.org/">PostgreSQL</a> in Mono: + There are many ADO.NET data providers for <a href="http://www.postgresql.org/">PostgreSQL</a>: + + There are two providers created specifically for PostgreSQL included with Mono: <ul> <li><a href="http://gborg.postgresql.org/project/npgsql/projdisplay.php">Npgsql</a> <ul> - <li>a .NET Managed Data Provider for PostgreSQL + <li>included with Mono</li> + + <li>a .NET Managed Data Provider for PostgreSQL</li> <li>Written in 100% C#</li> @@ -39,6 +43,8 @@ <li>Mono.Data.PostgreSQL (deprecated) <ul> + <li>included with Mono</li> + <li>Deprecated in favor of Npgsql</li> <li>Exists in namespace Mono.Data.PostgreSql and assembly Mono.Data.PostgreSql</li> @@ -51,6 +57,12 @@ </ul> </li> + <li><a href="http://sourceforge.net/projects/mysqlnet/">ByteFX.Data</a> has a provider for PostgreSQL too, but I do not know how well it works with Mono.</li> + + <li>There is another .NET data provider for PostgreSQL named <a href="http://sourceforge.net/projects/pgsqlclient/">PgSqlClient</a>, but I do not know if it works with Mono.</li> + + <li>If none of the above providers meet your needs. There is the ODBC and OLEDB providers included with Mono.</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 @@ -464,8 +476,8 @@ mono PostgresTest.exe 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); } @@ -548,8 +560,8 @@ mono TestExample.exe 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); } diff --git a/doc/sqlclient b/doc/sqlclient index 1cce85fd09b..d17f4695593 100755 --- a/doc/sqlclient +++ b/doc/sqlclient @@ -172,8 +172,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader["fname"]; - string LastName = reader["lname"]; + string FirstName = (string) reader["fname"]; + string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/doc/sqlite b/doc/sqlite index 5952bbfe789..35ee3056896 100755 --- a/doc/sqlite +++ b/doc/sqlite @@ -97,8 +97,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader[0]; - string LastName = reader[1]; + string FirstName = (string) reader[0]; + string LastName = (string) reader[1]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/doc/sybase b/doc/sybase index e9175348735..5b0c3ccba81 100755 --- a/doc/sybase +++ b/doc/sybase @@ -110,8 +110,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader["fname"]; - string LastName = reader["lname"]; + string FirstName = (string) reader["fname"]; + string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/doc/tdsclient b/doc/tdsclient index 56629335caf..fdfe6926c9f 100755 --- a/doc/tdsclient +++ b/doc/tdsclient @@ -115,8 +115,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader["fname"]; - string LastName = reader["lname"]; + string FirstName = (string) reader["fname"]; + string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/web/ado-net b/web/ado-net index ee9d633cbd8..c78b62edfd1 100644 --- a/web/ado-net +++ b/web/ado-net @@ -1,82 +1,22 @@ * ADO.NET -<p>Mono's ADO.NET Developers: - -<table border=1> - -<tr> - <td><b>Developer</b></td> - <td><b>Email</b></td> - <td><b>Contribution</b></td> -</tr> - -<tr> - <td>Rodrigo Moya</td> - <td>rodrigo -AT-<br> ximian.comNOSPAM</td> - <td>ADO.NET coordinator,<br> OLE DB provider,<br> and tests</td> -</tr> - -<tr> - <td>Daniel Morgan</td> - <td>danielmorgan -AT-<br> verizon.netNOSPAM</td> - <td>System.Data, SQL# Query Tool, MySQL, PostgreSQL, <br>Oracle providers,<br> and tests</td> -</tr> - -<tr> - <td>Tim Coleman</td> - <td>tim -AT- <br>timcoleman.comNOSPAM</td> - <td>Microsoft SQL Server, <br>Sybase, <br>TDS providers,<br> Oracle, - <br>and tests.<br> - He has - contributed <br>to other parts <br>of Mono too, <br>such as, - <br>EnterpriseServices, - XML, <br>and WebServices.</td> -</tr> - -<tr> - <td>Brian Ritchie</td> - <td>brianlritchie -AT-<br> hotmail.comNOSPAM</td> - <td>ODBC provider <br>and the ProviderFactory <br>in Mono.Data</td> -</tr> - -<tr> - <td>Vladimir Vukicevic</td> - <td>vladimir -AT-<br> pobox.comNOSPAM</td> - <td>SQL Lite provider. <br> He has contributed to GTK# <br>and mPhoto too.</td> -</tr> - -<tr> - <td>Christopher Bockner</td> - <td>cleared -AT-<br> rogers.comNOSPAM</td> - <td>IBM DB2 Universal <br>Database provider</td> -</tr> - -<tr> - <td>Ville Palo</td> - <td>vi64pa -AT-<br> koti.soon.fiNOSPAM</td> - <td>XML stuff <br>in System.Data <br>including DataSet <br> - and XmlDataDocument, <br>and tests</td> -</tr> - -<tr> - <td>Gonzalo Paniagua Javier</td> - <td>gonzalo -AT-<br> ximian.comNOSPAM</td> - <td>Integration between <br>System.Web and <br>System.Data</td> -</tr> - -<tr> - <td>Gaurav Vaish</td> - <td>gvaish -AT-<br> iitk.ac.inNOSPAM</td> - <td>Web controls</td> -</tr> - -<tr> - <td>Phillip Jerkins</td> - <td>Phillip.Jerkins -AT-<br> morgankeegan.comNOSPAM</td> - <td>Named Instance support <br>in System.Data.SqlClient</td> -</tr> - -</table> +** Data Access in Mono + +<ul> + <li>Today, our goal is to be compatible with .NET 1.0 and .NET 1.1. We also would like + to extend data access beyond what is included with .NET 1.0 and .NET 1.1, + such as, including access to more databases, such as, PostgreSQL and MySQL, + but also provide classes that help in creating data source-agnostic code, such as, Mono.Data.ProviderFactory.</li> + <li>In the future, we would like to be compatible with .NET 1.2. This + would include features like: + <ul> + <li><a href="http://longhorn.msdn.microsoft.com/lhsdk/ndp/daconworkingwithobjectspacesarchitecture.aspx">ObjectSpaces</a></li> + <li>provide support for hosting Mono languages (C-Sharp, MonoBASIC, etc...) + within a DBMS engine, such as, MySQL or PostgreSQL.</li> + <li>implement .net 1.2 classes, such as, those found in System.Data.ProviderBase</li> + <li>other stuff which can be brought up on the mono-list</li> + </ul></li> +</ul> ** Bugs and Feature Requests @@ -88,14 +28,14 @@ and easy to create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li> - <li>Any RFE (Request For Enhancement) for features missing or new functionality - should be entered as a bug in Bugzilla too</li> + <li>Any requests for new features or missing functionality + can entered as a bug in Bugzilla too</li> </ul> ** ADO.NET Data Providers -<p>List of ADO.NET Data Providers working in Mono: +<p>Mono has many ADO.NET Data Providers to get you connected: <ul> <li><a href="http://www.go-mono.com/ibmdb2.html">IBM DB2 Universal Database</a></li> @@ -147,39 +87,38 @@ <p>Some tools that can be used for ADO.NET and other technologies (ASP.NET, XML, etc). <ul> - <li><b>SQL# CLI</b> - a SQL query tool with a command-line interface. - It can be used to enter and execute SQL statements or - execute a batch of SQL commands from a file. It can + <li><p><b>SQL# command line query tool</b> is a command-line tool to + enter and execute SQL statements or + execute a batch of SQL commands from a file. + <p>It can be used to test connection strings, connect to various ADO.NET - providers, save output to text, html, or xml. It is a work-in-progress. - The SQL# CLI is distributed with the + providers, save output to text, html, or xml. + <p>The SQL# CLI is distributed with the Mono runtime and class libraries as an executable assembly sqlsharp.exe. - The source to SQL# CLI can be found in the mcs source at + <p>The source to SQL# CLI can be found in the mcs source at mcs/tools/SqlSharp/SqlSharpCli.cs </li> - <li><p><b>SQL# GUI - a graphical SQL query tool</b> allows a user - to enter SQL commands in a top panel which is a text editor. It - has a toolbar and menu for various tasks, such as, executing + <li><p><b>SQL# For GTK#</b> - is a graphical SQL database query tool</b> allows a user + to enter SQL commands in a top panel which is a text editor. + <p>It has a toolbar and menu for various tasks, such as, executing SQL commands one-at-a-time or in a batch. The results would appear in a bottom panel in a grid or could be saved to a file (xml, html, csv). - Also, the bottom panel would allow logging of SQL command executed. - Currently, there is a <a href="http://go-mono.com/images/sqlsharp.png">SQL# For GTK#</a> which - provides a GUI interface using the <a href="http://gtk-sharp.sourceforge.net">Gtk#</a> toolkit. SQL# For GTK# - is a work-in-progress and can be found in the mcs source at - mcs/tools/SqlSharp/gui/gtk-sharp</li> + <p>Also, the bottom panel would allow logging of SQL command executed. + Here is a screenshot of <a href="http://go-mono.com/images/sqlsharp.png">SQL# For GTK#</a> which + provides a GUI interface using the <a href="http://gtk-sharp.sourceforge.net">Gtk#</a> toolkit. + <p>SQL# For GTK# can be found in mono cvs as sqlsharpgtk.</li> </ul> <p>Tools we would like to have, but they have not been created yet: <ul> - <li><b>XML Schema Definition tool</b> <a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpconxmlschemadefinitiontoolxsdexe.asp">xsd.exe</a> needs - to be created. Maybe this TODO item should be at the System.XML web page instead. - + <li>Mono has an <b>XML Schema Definition tool</b> (xsd.exe).</b> + <ul> <li>This tool - would work like the xsd.exe tool included with - the .NET Framework. The Xsd.exe tools has the
+ would works like the xsd.exe tool included with + the .NET Framework. The Xsd.exe tool has the
following uses:
<ul>
<li><b>XDR to XSD</b> - used to generate an XML schema from an XDR (XML Data Reduced schema) file.
@@ -330,7 +269,7 @@ Mike Kestner or Rachel Hestilov would be the best people to ask for help on GTK#. <p><b>Integration with QT#</b> has not been started. Any information on - how this can be done is appreciated. Adam Treat would be the best + how this can be done is appreciated. Marcus would be the best person to ask about QT#. <p><b>Building System.Data</b> diff --git a/web/mysql b/web/mysql index 7b0a4d5811b..169aae5bae3 100755 --- a/web/mysql +++ b/web/mysql @@ -283,8 +283,8 @@ mono TestExample.exe 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); } @@ -175,8 +175,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); } diff --git a/web/oledb b/web/oledb index caa032fd8bb..1dabe6244ed 100755 --- a/web/oledb +++ b/web/oledb @@ -109,8 +109,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); } diff --git a/web/oracle b/web/oracle index 921954aef0b..16188b522ab 100755 --- a/web/oracle +++ b/web/oracle @@ -10,7 +10,7 @@ <li>Works with Oracle 8i</li> - <li>Untested, but should work with Oracle 9i</li> + <li>May work with Oracle 9i</li> <li>Uses the Oracle CLI (Call Level Interface) which is a C library (API) for the Oracle Client software</li> @@ -19,8 +19,6 @@ <li>Created by Daniel Morgan and Tim Coleman</li> - <li>Does not support trusted connections</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 @@ -64,14 +62,12 @@ <li>Handling of various data types need to be added.</li> - <li>Data Adapter exists, and a DataSet can be filled using it. The - Data Adapter is abstract enough that it should work as expected.</li> + <li>Data Adapter exists, and a DataSet can be filled using it.</li> <li>Lots of missing functionality and bugs.</li> <li>Works with SQL# command-line and GTK# versions in cvs. Only works with - simple character data though. SQL# For GTK# can only show the results to - the TextView because the Data Adapter is not yet available</li> + simple character data though.</li> </ul> @@ -83,7 +79,8 @@ <li>transactions (WORKING)</li> <li>Stored Procedures, Functions, and Packages support</li> <li>Be able to fill a DataTable in a DataSet via a data adapter (IN PROGRESS)</li> - <li>Support for Oracle 8i and 9i (UNKNOWN)</li> + <li>Support for Oracle 8i (WORKING</li> + <li>Support for Oracle 9i (UNKNOWN)</li> <li>Support LOBs</li> <li>Support all the data types</li> <li>Implement Connection pooling</li> @@ -96,7 +93,7 @@ <ul> <li>Have a working mono and mcs</li> - <li>Have access to an Oracle 8i database or download it from + <li>Have access to an Oracle 8i or 9i database or download it from <a href="http://www.oracle.com/">Oracle</a>. If you are connecting remotely to an Oracle database, you need the Oracle client software. Registration to the <a href="http://technet.oracle.com/">Oracle Technology Network</a> is free. If installing on Linux, @@ -129,16 +126,16 @@ "Data Source=testdb;" + "User ID=scott;" + "Password=tiger;"; - IDbConnection dbcon; + OracleConnection dbcon = null; dbcon = new OracleConnection (connectionString); dbcon.Open (); - IDbCommand dbcmd = dbcon.CreateCommand (); + OracleCommand dbcmd = dbcon.CreateCommand (); string sql = "SELECT ename, job FROM scott.emp"; dbcmd.CommandText = sql; - IDataReader reader = dbcmd.ExecuteReader (); + OracleDataReader reader = dbcmd.ExecuteReader (); while (reader.Read ()) { - string employeeName = reader["ename"]; - string job = reader["job"]; + string employeeName = (string) reader["ename"]; + string job = (string) reader["job"]; Console.WriteLine ("Employee Name: {0} Job: {1}", employeeName, job); } diff --git a/web/postgresql b/web/postgresql index 6e9643af234..6e5bb4f2483 100644 --- a/web/postgresql +++ b/web/postgresql @@ -1,10 +1,10 @@ * PostgreSQL and Mono When it comes to Mono and PostgreSQL, there are many ways - you can handle your data. You have Data Providers which can be used - to retrieve or manipulate data from a remote application written for Mono. - Then you have the ability to host Mono within PostgreSQL to - have the applications run on the server which makes things faster. + you can handle your data. You have many Mono Data Providers which can be used + to access data from a application written for Mono. + Then there is the future goal of having the ability to host Mono within PostgreSQL to + have the applications run on the server which makes things much faster. * Hosting Mono in PostgreSQL @@ -14,13 +14,17 @@ * Data Providers - There are two ADO.NET data providers for <a href="http://www.postgresql.org/">PostgreSQL</a> in Mono: + There are many ADO.NET data providers for <a href="http://www.postgresql.org/">PostgreSQL</a>: + + There are two providers created specifically for PostgreSQL included with Mono: <ul> <li><a href="http://gborg.postgresql.org/project/npgsql/projdisplay.php">Npgsql</a> <ul> - <li>a .NET Managed Data Provider for PostgreSQL + <li>included with Mono</li> + + <li>a .NET Managed Data Provider for PostgreSQL</li> <li>Written in 100% C#</li> @@ -39,6 +43,8 @@ <li>Mono.Data.PostgreSQL (deprecated) <ul> + <li>included with Mono</li> + <li>Deprecated in favor of Npgsql</li> <li>Exists in namespace Mono.Data.PostgreSql and assembly Mono.Data.PostgreSql</li> @@ -51,6 +57,12 @@ </ul> </li> + <li><a href="http://sourceforge.net/projects/mysqlnet/">ByteFX.Data</a> has a provider for PostgreSQL too, but I do not know how well it works with Mono.</li> + + <li>There is another .NET data provider for PostgreSQL named <a href="http://sourceforge.net/projects/pgsqlclient/">PgSqlClient</a>, but I do not know if it works with Mono.</li> + + <li>If none of the above providers meet your needs. There is the ODBC and OLEDB providers included with Mono.</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 @@ -464,8 +476,8 @@ mono PostgresTest.exe 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); } @@ -548,8 +560,8 @@ mono TestExample.exe 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); } diff --git a/web/sqlclient b/web/sqlclient index 1cce85fd09b..d17f4695593 100755 --- a/web/sqlclient +++ b/web/sqlclient @@ -172,8 +172,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader["fname"]; - string LastName = reader["lname"]; + string FirstName = (string) reader["fname"]; + string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/web/sqlite b/web/sqlite index 5952bbfe789..35ee3056896 100755 --- a/web/sqlite +++ b/web/sqlite @@ -97,8 +97,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader[0]; - string LastName = reader[1]; + string FirstName = (string) reader[0]; + string LastName = (string) reader[1]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/web/sybase b/web/sybase index e9175348735..5b0c3ccba81 100755 --- a/web/sybase +++ b/web/sybase @@ -110,8 +110,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader["fname"]; - string LastName = reader["lname"]; + string FirstName = (string) reader["fname"]; + string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } diff --git a/web/tdsclient b/web/tdsclient index 56629335caf..fdfe6926c9f 100755 --- a/web/tdsclient +++ b/web/tdsclient @@ -115,8 +115,8 @@ dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { - string FirstName = reader["fname"]; - string LastName = reader["lname"]; + string FirstName = (string) reader["fname"]; + string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } |