public StatusCollection GetStatus() { StatusCollection status = new StatusCollection(); using (StatusDataAdapter adapter = new StatusDataAdapter()) { IDataReader dr = adapter.GetStatus(); while (dr.Read()) { status.Add(PopulateReader(dr)); } dr.Dispose(); adapter.Dispose(); return status; } }