Create unique attribute beyond Primary Key in code-first

Question

I’m creating a table of Logradouro where the countryside CEP is not the primary key, but should be unique.
How do I do it using code-first in the Entity 6.0?

To create primary key I use the method HasKey:

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

I saw that in this method it is possible to use more than one field creating composite key. If the CEP must be unique and indexed it must be table key too?

Answer 1

You can use [Index]

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

https://msdn.microsoft.com/en-us/data/jj591583.aspx#Index

If you have to use modelBuilder, use it like this:

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

https://stackoverflow.com/questions/22618237/how-to-create-index-in-entity-framework-6-2-with-code-first