Index Attribute

Entity Framework 6 provides the [Index] attribute to create an index on a particular column in the database, as shown below:

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

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

You can also make it a clustered index by specifying IsClustered = true or create a unique index by specifying IsUnique=true.

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