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

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

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

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

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