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

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

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

            return(coll);
        }