I am basically trying to handle unique constraint validation in my .Net API. I have two unique key cosntraints on two fields in my table.
If you see my code below , I am trying to check if the record exists. I am looking at returning a boolean value if the record exist. is that possible. For the time being, I am returning null.
Is this the best way to do it.
[HttpPost]
        [SkipTokenAuthorization]
        [Route("api/classificationoverrides/create")]
        public IHttpActionResult Create(ClassificationItemViewModelCreate model)
        {
            var mgrClassificationService = GetService<MGR_STRT_CLASSIFICATION>();
            var isExists = mgrClassificationService.Where(x =>
                x.MANAGERSTRATEGYID == model.ManagerStrategyId && x.PRODUCT_ID == model.ProductId).FirstOrDefault();
            if (isExists == null)
            {
                var mgrClassficationOverride = new MGR_STRT_CLASSIFICATION();
                if (model != null)
                {
                    mgrClassficationOverride.PRODUCT_ID = model.ProductId;
                    mgrClassficationOverride.LEGACY_STRATEGY_ID = model.LegacyStrategyId;
                    mgrClassficationOverride.STRATEGY_ID = model.StrategyId;
                    mgrClassficationOverride.MANAGERSTRATEGY_TYPE_ID = model.ManagerStrategyTypeId;
                    mgrClassficationOverride.MANAGERSTRATEGYID = model.ManagerStrategyId;
                    mgrClassficationOverride = mgrClassificationService.Create(mgrClassficationOverride);
                }
                return Ok(mgrClassficationOverride);
            }
            else
            {
                return null;
            }
        }

