public ProspectRoomCollection FetchAll()
 {
     ProspectRoomCollection coll = new ProspectRoomCollection();
     Query qry = new Query(ProspectRoom.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public ProspectRoomCollection FetchByQuery(Query qry)
 {
     ProspectRoomCollection coll = new ProspectRoomCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }