Unique constraint entity framework

Question

I'm using MS SQL Server 2012 + the Entity Framework 6.1.1. I have created a model using the designer. Now, I would like to add a unique to an attribute. How can I achieve this using the designer / keep the model generation?

Edit: I do the model first approach

Thank you

Model first? Or database first? – Youp Bernoulli Jan 14 '15 at 23:12 — Youp Bernoulli, Jan 14 '15 at 23:12

score 1 · Answer 1 · edited May 23 '17 at 12:10

1

Read this! It should help you in the right direction...

The idea is to use code like this:

CreateIndex("dbo.Users","Username",true);

Which is a EF method. I don't think it's possible in the designer then...

EDIT

Found this post that states that unique constraints are possible (not in the designer, but in code) like this:

[Index(IsUnique = true)]
public string EmailAddress { get; set; }

edited May 23 '17 at 12:10

Community

1
1

answered Jan 14 '15 at 23:14

Youp Bernoulli

5,303
5
39
59

So not in model first. `[Index(IsUnique = true)]` is code first, from EF 6.1. – Csaba Toth Apr 08 '17 at 07:10

Unique constraint entity framework

1 Answers1