public OrderNumberTableCollection FetchByQuery(Query qry)
        {
            OrderNumberTableCollection coll = new OrderNumberTableCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public OrderNumberTableCollection FetchAll()
        {
            OrderNumberTableCollection coll = new OrderNumberTableCollection();
            Query qry = new Query(OrderNumberTable.Schema);

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

            return(coll);
        }