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

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

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

            return(coll);
        }