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

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

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

            return(coll);
        }