public PublishipAdvanceTitleTableCollection TitlesFetchByQuery(Query qry)
        {
            PublishipAdvanceTitleTableCollection coll = new PublishipAdvanceTitleTableCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PublishipAdvanceTitleTableCollection TitlesFetchAll()
        {
            PublishipAdvanceTitleTableCollection coll = new PublishipAdvanceTitleTableCollection();
            Query qry = new Query(PublishipAdvanceTitleTable.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public PublishipAdvanceTitleTableCollection TitlesFetchByPaOrderID(object PAOrderID)
        {
            PublishipAdvanceTitleTableCollection coll = new PublishipAdvanceTitleTableCollection().Where("PAOrderID", PAOrderID).Load();

            return(coll);
        }