string sql = "select * from author";
NpgsqlConnection conn = new NpgsqlConnection(sAccessConnection);
conn.Open();
NpgsqlCommand objCommand = new NpgsqlCommand(sql, conn);
NpgsqlDataReader dr = objCommand.ExecuteReader();
//int count = Convert.ToInt32(objCommand.ExecuteScalar());
while(dr.Read())
{
for(int i=0;i<dr.FieldCount;i++)
{
Console.Write("{0} \t",dr[i]);
}
Console.WriteLine();
}
conn.Close();