mono/mcs/class/System.Data/Test/OdbcTest.cs

//
// OdbcTest.cs - Test for the ODBC ADO.NET Provider in System.Data.Odbc 
//
// The test works on Windows XP using Microsoft .NET Framework 1.1 Beta
//
// To compile under Windows using Microsoft .NET 1.1
// E:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\csc OdbcTest.cs /reference:System.Data.dll
//
// To compile under Windows using Mono:
// mcs OdbcTest.cs -r System.Data.dll
//
// I have not tested it on Linux using unixODBC
//
// Author:
//     Daniel Morgan <[email protected]>
//

using System;
using System.Data;
using System.Data.Odbc;

namespace Test.OdbcTest
{
	class OdbcTest
	{
		[STAThread]
		static void Main(string[] args)
		{
			OdbcConnection dbcon = new OdbcConnection();
			// connection string to a Microsoft SQL Server 2000 database
			// that does not use a DSN
			//dbcon.ConnectionString = 
			//	"DRIVER={SQL Server};" + 
			//	"SERVER=(local);" + 
			//	"Trusted_connection=true;" +
			//	"DATABASE=pubs;";

			// connection string that uses a DSN.
			dbcon.ConnectionString = 
				"DSN=LocalServer;UID=sa;PWD=";
				
			dbcon.Open();

			OdbcCommand dbcmd = new OdbcCommand();
			dbcmd.Connection = dbcon;
			dbcmd.CommandType = CommandType.Text;
			dbcmd.CommandText = "SELECT lname FROM employee";
			
			OdbcDataReader reader;
			reader = (OdbcDataReader) dbcmd.ExecuteReader();

			while(reader.Read()) {
				Console.WriteLine("Last Name: " + reader[0].ToString());
			}
			reader.Close();
			dbcmd.Dispose();
			dbcon.Close();
		}
	}
}