Entity Framework 6.0 Tutorials（10）：Index Attribute

Index Attribute:

Entity Framework 6 provides Index attribute to create Index on a particular column in the database as shown below:

class Student
{
    public Student()
    {
    }

    public int Student_ID { get; set; }
    public string StudentName { get; set; }
        
    [Index]
    public int RegistrationNumber { get; set; }
}

 

By default, Index name will be IX_{property name}. However, you can also change the Index name.

You can also make it a Clustered index by specifying IsClustered = true and a unique index by specifying IsUnique=true.

[Index( "INDEX_REGNUM", IsClustered=true, IsUnique=true )]
public int RegistrationNumber { get; set; }

 

Download Code-First sample project for Index attribute demo.