CODEWITHSUNDEEP
entity-frameworkentity-framework-4.1ef-code-firstkeyunique
y.selivonchyk
y.selivonchyk

Reputation: 9900

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

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?

Upvotes: 9

Views: 11188

Answers (2)

Jayantha Lal Sirisena
Jayantha Lal Sirisena

Reputation: 21366

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; }

Upvotes: 15

Smudge202
Smudge202

Reputation: 4687

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

Upvotes: 2

Related Questions