how to validate UNIQUE KEY in mvc 5

Question

1.44/5 (2 votes)

See more:

hi to all,
Kindly help me how to validate unique key here i'm using this code in modal

[Index(IsUnique = true)]
[Required(ErrorMessage = "Branch Code is required.")]
[RegularExpression(@^[a-zA-Z0-9'' ']+, ErrorMessage =Special characters ( ,@/)(=][|\!`’%$#^”&* ) are not allowed in the name.)]
[StringLength(3)]
[Column(TypeName = char)]
public string Branch_Cde { get; set; }

if i give same Branch code then it will occur exception. how to validate above unique key.

Posted 15-Jul-14 19:22pm

JOTHI KUMAR Member 10918227

Add a Solution

Comments

jo.him1988 16-Jul-14 2:14am

you have to check it by code because its needed database Existance so if you have textbox write event to validate the branch code

Sergey Alexandrovich Kryukov 16-Jul-14 2:32am

Why? Normally, developers don't validate uniqueness but instead generate unique key in first place...
—SA

JOTHI KUMAR Member 10918227 16-Jul-14 2:36am

thanks for reply. i'm new for mvc 5 so kindly explain me detail

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yannick Brodard · Answer 1 · 2014-07-15T22:40:00

You need a "Base Model" from where you will inherit the unique ID.

C#

public  class BaseModel<t> where T : BaseModel<t>
{
    [Key, Required, DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    // You can do a lot of very useful code here...
}

C#

public class PersonModel : BaseModel<personmodel>
{
    public string Name { get; set; }
    public DateTime Birth{ get; set; }
}

And of course add it to your entityframework context

C#

public class SMSServiceContext : DbContext
{
    public SMSServiceContext()
    : base()
    {
    
    }

    public DbSet<personmodel> PersonModels{ get; set; }
    // Add other tables here...
    
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
    }

The unique Key will be automatic and unique. This is how I do it when I work with entityframework anyways.

I hope I answered your question. If not, please inform me :)