How to set Not Null and Unique key constraint on a property from mvc model

Question

How can I apply not null and unique key constraint on a property from asp.net MVC model,

Below is my code:

public class Role
{
    public int id { get; set; }

    [Required]
    [Index("RoelsIndex",IsUnique=true)]        
    public string Roles { get; set; }
}

I am inserting record from sql server,At that time it is allowing null values and unique key is not applying. — madhu, Jul 11 '14 at 09:50
if you use EF code first properly to generate the database, the not null constraint will be added into the column, and inserting from application will throw `DbEntityValidationException` — Yuliam Chandra, Jul 11 '14 at 10:11
If I include [MaxLength(15)] then it is working fine,For int type I didn't include [MaxLength(11)] it was worked but string type I included [MaxLength(11)] then only working! — madhu, Jul 11 '14 at 12:03

score 0 · Answer 1 · answered Jul 11 '14 at 10:44

Not sure what's your problem but Required and Index work fine when I try it.

public class Product
{
    public int Id { get; set; }
    [Required]
    [Index(IsUnique = true)]
    [MaxLength(400)]
    public string Name { get; set; }
}
public class AppContext : DbContext
{
    public DbSet<Product> Products { get; set; }
}

Result

How to set Not Null and Unique key constraint on a property from mvc model

1 Answers1