public OfficeTableCollection FetchAll()
 {
     OfficeTableCollection coll = new OfficeTableCollection();
     Query qry = new Query(OfficeTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public OfficeTableCollection FetchByQuery(Query qry)
 {
     OfficeTableCollection coll = new OfficeTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public OfficeTableCollection FetchByID(object OfficeID)
 {
     OfficeTableCollection coll = new OfficeTableCollection().Where("OfficeID", OfficeID).Load();
     return coll;
 }