I have an endpoint that creates a new category, the category entity has a property called CategoryCode, which is unique and is calculated based on the last value in the database.

I Have an endpoint that creates a new category, the category entity has a property called CategoryCode, which is unique and is calculated based on the last value in the database, for simplicity let’s just assume that i get the max CategoryCode value and increment it.