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

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

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

            return(coll);
        }