#DATA ANNOTATIONS COMPOSITE KEY UPDATE#
#DATA ANNOTATIONS COMPOSITE KEY SERIES#

Creating a custom remote attribute and override IsValid() methodĪ) Adding Model Validation Error Dynamically in the Controller Action Method.Adding model validation error dynamically in the controller action method.To make server side validation work, when JavaScript is disabled, there are 2 ways: That's why it's always important to have server side validation along with client side validation. As a result, any wicked user will be able to insert duplicate values by disabling JavaScript in his browser. Because this is a JavaScript based client side validation which makes an asynchronous AJAX call to the server side validation method. Till now, everything is working fine!! Now think! What will happen if the JavaScript is disabled in client browser? Will the validation work anymore?Ībsolutely no! The validation will not work anymore.

You can also be able to Edit/Update any field of an existing entity/record by satisfying the validation. You will get the validation error message as follows: Now run the project and try to insert a product entity with a product name that already exists in the table. Here is our product model class which will be used throughout this article: So it is rational to not permit the user to insert a product name that already exists in the table.

Suppose we have an Inventory where there is a Product table/ class which is used to track all products as a list of products. In the last part of the article, to make the CustomRemoteValidation attribute reusable irrespective of properties and class, help has been taken from the very famous KudVenkat blog. Sometimes, we are in need of not permitting the duplicate value of a column or property in a database table, such as: for a username column or property in database table, we should not allow user to insert a value that already exists in the database table because a username is a unique value.

#DATA ANNOTATIONS COMPOSITE KEY SERIES#

This is Part 2 of the series 'Best ways of implementing Uniqueness or Unique Key attribute on a model property in ASP.

#DATA ANNOTATIONS COMPOSITE KEY UPDATE#

This update eradicated this problem and made the code more simple to understand. It did not allow to pass the original value of unique field while updating the others. Like Part 1, before this update, unfortunately there was a serious problem which went unnoticed that the method used to work fine in case of creating new entity only but did not work properly in case of Edit/Updating any existing entity.

Data annotations composite key