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

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

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public HitblCampaignsCmpCollection FetchByID(object CtyId)
        {
            HitblCampaignsCmpCollection coll = new HitblCampaignsCmpCollection().Where("CTY_ID", CtyId).Load();

            return(coll);
        }