using System;
using System.Data;
using System.Data.OleDb;
using Microsoft.Data.Odbc;
using System.Collections;

namespace DataLibrary
{
	public class Author
	{
		public Author()
		{
		}

		public ArrayList GetAll()
		{
			ArrayList output = new ArrayList();

			OleDbConnection myConnection = new OleDbConnection("Provider=MySQLProv;Location=localhost;Data Source=dbarticle;User=root;Password=;");
			myConnection.Open();

			OleDbCommand myCommand = myConnection.CreateCommand();
			myCommand.CommandText = "SELECT Author_id, first, last FROM Author;";
			OleDbDataReader myReader = myCommand.ExecuteReader();
			try 
			{
				while (myReader.Read()) 
				{
					Hashtable row = new Hashtable();
					row[ "author_id" ] = myReader.GetInt32( 0 );

					row[ "first" ] = myReader.GetString( 1 );

					row[ "last" ] = myReader.GetString( 2 );

					output.Add( row );
				}
			}
			finally 
			{
				myReader.Close();
			}

			myConnection.Close();

			return output;
		}
	}
}