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

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

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

            return(coll);
        }