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

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

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

            return(coll);
        }