How to Check if the UserName is Unique in MVC 5

In a real time web application the user registration page has a username field where the user must specify a unique username. Once a user provides a username, then to check if the field is unique, a call to the database must be made. If the field is not unique a validation error message is displayed to the front-end user such as “UserName already in use”.

Let's look at it practically.

DEMO

Step 1

The first step is to create a table where we will store the details.

Step 2

The next step is to create an MVC 5 web application.



Click OK.

Choose template as empty and select MVC as the project type.



Click OK.

Step 3

The next step is to add an ADO.Net Entity Data Model in the Models folder.



Provide this Model a name and click OK.



Choose EF Designer from database.



Click Next.

Add a new connection by clicking on the New Connection button.



Click OK.

Provide the connection settings a name.



Click Next.

Choose the required table.



Click Finish.

Step 4

Change the entity name from tblUser to User.



Step 5

The next step is to add a Controller.



Select MVC 5 Controller with views, using Entity Framework.



Click Add.

Note

This template will add all the required action methods, views and the required HTML codes for us.

Choose the Model class : User
Choose Data Context class :UserDbContext



Provide the controller a name.

Click Add

Run the application and click the Create New link.

Specify the user name and password.

Click Create.





So, a record has been added to our database.

Now add a new record and specify the same user name again and click create.

Look at the records we have. We have two records with the same user name. But in reality two users cannot have the same user name.



Now let's see how to solve this problem.

To solve this problem we can use RemoteAttribute.

Step 1

In the HomeController create a method and for that write the following.