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