public TblReasonCollection FetchByQuery(Query qry)
        {
            var coll = new TblReasonCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public TblReasonCollection FetchAll()
        {
            var coll = new TblReasonCollection();
            var qry  = new Query(TblReason.Schema);

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

            return(coll);
        }