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 the index name.
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; }
0 comments:
Post a Comment
Note: only a member of this blog may post a comment.