public List<DBHost> GetHosts ()
{
List<DBHost> result = new List<DBHost> ();
using (IDbCommand cmd = CreateCommand ()) {
cmd.CommandText = "SELECT * FROM Host ORDER BY host";
using (IDataReader reader = cmd.ExecuteReader ()) {
while (reader.Read ()) {
result.Add (new DBHost (reader));
}
}
}
return result;
}