How to add unique non primary-key field to entity using Entity Framework 4.1?

Question

We are using Entity Framework 4.1 Code first.

We've got user entity with primary key set to UserId and need UserLogin to be unique. How can it be done?

possible duplicate of Unique key with EF code first

Ladislav Mrnka
– Ladislav Mrnka

2011-09-05 09:54:41 +00:00
Commented Sep 5, 2011 at 9:54 — Ladislav Mrnka
– Ladislav Mrnka, Commented Sep 5, 2011 at 9:54

Ehsan88 · Accepted Answer · 2016-01-21 20:19:52Z

15

Entity Framework does not support Unique constraints. You can create them using a SQL Query to generate unique constrains when initializing the database. Write your custom initializer for the model and execute SQL command to generate constrain.

Edit

Now (EF 6.1 onwards )you can easily have unique constrains ,

[Index("UserLoginIndex", IsUnique = True)]
public string UserLogin { get; set; }

edited Jan 21, 2016 at 20:19

Ehsan88

3,8315 gold badges33 silver badges55 bronze badges

answered Sep 5, 2011 at 9:56

Jayantha Lal Sirisena

21.4k11 gold badges74 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

calebboyd Over a year ago

As of EF 6.1 the [Index(IsUnique = true)] data annotation is available

Jayantha Lal Sirisena Over a year ago

Yeah it's not released yet though.

calebboyd Over a year ago

The nuget package was released on 3/17/14..

Smudge202 · Accepted Answer · 2011-09-05 09:53:29Z

2

Check out the unique constraints, I think that's what you're looking for?

http://weblogs.asp.net/manavi/archive/2011/01/23/associations-in-ef-code-first-ctp5-part-3-one-to-one-foreign-key-associations.aspx

answered Sep 5, 2011 at 9:53

Smudge202

4,6972 gold badges28 silver badges44 bronze badges

2 Comments

Ladislav Mrnka Over a year ago

That is answer pointing to non existing API. No EF version supports this yet.

Smudge202 Over a year ago

New link supported by CTP5 added, that any use?

Collectives™ on Stack Overflow

How to add unique non primary-key field to entity using Entity Framework 4.1?

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related