using System;
using System.Data;
using Pervasive.Data.SqlClient;
using System.IO;

namespace SimpleAdoNetConsole
{
	class Class1
	{
		[STAThread]
		static void Main(string[] args)
		{
			try
			{
				PsqlConnection conn=new PsqlConnection("ServerDSN=demodata;UID=;PWD=;Server=localhost;");
				conn.Open();
				Console.WriteLine("ServerName: " + conn.ServerName.ToString());
				Console.WriteLine("ServerDSN: " + conn.ServerDSN.ToString());
				// Create a SQL command
				string SQLstr = "select * from class";
		
				PsqlCommand DBCmd = new PsqlCommand(SQLstr, conn);
				PsqlDataReader myDataReader;
				myDataReader = DBCmd.ExecuteReader();
				Console.WriteLine("FieldCount: " + myDataReader.FieldCount.ToString());
				//Console.WriteLine("Records Affected:" + myDataReader.RecordsAffected.ToString());
				Console.ReadLine();
				while (myDataReader.Read())
				{
					for (int i=0;i<myDataReader.FieldCount;i++)
					{
						Console.WriteLine("Field " + i.ToString() + ": " + myDataReader[i].ToString());
					}
				}
				myDataReader.Close();
				conn.Close();
				Console.WriteLine("Press Enter to continue");
				Console.ReadLine();
			}
			catch (Exception ex)
			{
				Console.WriteLine(ex.Message);
				Console.ReadLine();
			}
			
		}
	}
}