public PublishipAdvanceTitleTableCollection FetchAll()
 {
     PublishipAdvanceTitleTableCollection coll = new PublishipAdvanceTitleTableCollection();
     Query qry = new Query(PublishipAdvanceTitleTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public PublishipAdvanceTitleTableCollection FetchByQuery(Query qry)
 {
     PublishipAdvanceTitleTableCollection coll = new PublishipAdvanceTitleTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public PublishipAdvanceTitleTableCollection FetchByID(object PATitleID)
 {
     PublishipAdvanceTitleTableCollection coll = new PublishipAdvanceTitleTableCollection().Where("PATitleID", PATitleID).Load();
     return coll;
 }