Create unique attribute beyond the Primary Key in code-first

Question

Create unique attribute beyond the Primary Key in code-first

Navigation

#1 by (3 votes)

4

I am creating a Logradouro table where the CEP field is not the primary key, but must be unique. How do I do this using code-first in Entity 6.0 ?

To create primary key I use the HasKey method:

ToTable("Logradouros").HasKey(x => x.LogradouroId);

I saw that in this method you can use more than one field by creating composite key. If CEP needs to be unique and indexed should it be table key too?

c# entity-framework-6 code-first

asked by anonymous 16.06.2016 / 21:27

1 answer

Create SplashScreen to show file copy progress How to put ALT in a Background-Image? How to make a Background-Image more accessible and semantic?

score 3 · Accepted Answer

You can use [Index]

[Index(IsUnique = true)] 
[StringLength(200)] 
public string Username { get; set; }

link

If you are using modelBuilder, use the following:

modelBuilder.Entity<User>()
    .HasIndex("IX_Username",          // Provide the index name.
        e => e.Property(x => x.Username))  // Multiple columns as desired.

link