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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PdIssnCollection FetchAllPaged(int start, int pageLength)
        {
            int startIndex;

            if (start == 0)
            {
                startIndex = 1;
            }
            else
            {
                startIndex = start / pageLength;
            }
            PdIssnCollection coll = new PdIssnCollection();
            Query            qry  = new Query(PdIssn.Schema);

            qry.PageSize  = pageLength;
            qry.PageIndex = startIndex;
            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }