Entity Framework table constraints

Question

I want to store such object inside the database

public class Account
{
    [Key]
    public int Id { get; set; }

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

    [Required]
    public string Password { get; set; }

    [Required]
    public string Email { get; set; }
}

Is any way to say to database that property Email must have appropriate form? So that if i want to add account

var account = new Account
{
     UserName = "X",
     Password = "X",
     Email = "NotValidEmail"
}

database will not accept that object.

Berkay Yaylacı · Accepted Answer · 2016-08-24T11:03:41.927

1

Add this over Email property,

 [EmailAddress(ErrorMessage = "Invalid Mail Address")]

hope helps,

edited Aug 24 '16 at 11:03

answered Aug 24 '16 at 10:49

Berkay Yaylacı

4,383
2
20
37

Had added that annotation, but nothing happend :( – igorr Aug 24 '16 at 10:51
Is any way to validate string column using regexp? – igorr Aug 24 '16 at 11:22
@igorr Sure, put `[RegularExpression(@"Regex")]` over property. – Berkay Yaylacı Aug 24 '16 at 11:36

score 0 · Answer 2 · edited May 23 '17 at 12:14

0

Well, personally I don't think that data base should know if the format is right or not. It is your job to be sure it is before adding the object to data base, more details could be found this answer.

edited May 23 '17 at 12:14

Community

1
1

answered Aug 24 '16 at 10:57

Ioana Stoian

146
1
10

Assume that application has two layers. 1. DataStorage layer, 2.Presentation layer. The second layer could be implemented by many people, but storage layer would be constant. At that point i want to have mechanism to prevent adding wrong data that comes from presentation layer, becouse that data probably is not mine. – igorr Aug 24 '16 at 11:04

Entity Framework table constraints

2 Answers2