// POST: odata/ProductSubcategories
        public IHttpActionResult Post(DimProductSubcategory dimProductSubcategory)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.DimProductSubcategories.Add(dimProductSubcategory);
            db.SaveChanges();

            return(Created(dimProductSubcategory));
        }
        // DELETE: odata/ProductSubcategories(5)
        public IHttpActionResult Delete([FromODataUri] int key)
        {
            DimProductSubcategory dimProductSubcategory = db.DimProductSubcategories.Find(key);

            if (dimProductSubcategory == null)
            {
                return(NotFound());
            }

            db.DimProductSubcategories.Remove(dimProductSubcategory);
            db.SaveChanges();

            return(StatusCode(HttpStatusCode.NoContent));
        }
        // PUT: odata/ProductSubcategories(5)
        public IHttpActionResult Put([FromODataUri] int key, Delta <DimProductSubcategory> patch)
        {
            Validate(patch.GetInstance());

            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            DimProductSubcategory dimProductSubcategory = db.DimProductSubcategories.Find(key);

            if (dimProductSubcategory == null)
            {
                return(NotFound());
            }

            patch.Put(dimProductSubcategory);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!DimProductSubcategoryExists(key))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(Updated(dimProductSubcategory));
        }