با روش Fluent
- تک ستونی:
- چند ستونی:
- منحصربفرد:
- نوع Clustered
- تک ستونی:
modelBuilder.Entity<People>() .Property(x => x.Firstname) .HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("ix_people_firstname")));
modelBuilder.Entity<People>() .Property(x => x.Firstname) .HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("ix_people_fullname", 1))); modelBuilder.Entity<People>() .Property(x => x.Lastname) .HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("ix_people_fullname", 2)));
modelBuilder.Entity<People>() .Property(x => x.NationalInsuranceNo) .HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("ix_people_nationalinsurance") {IsUnique = true}));
modelBuilder.Entity<People>() .Property(x => x.Id) .HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("ix_people_nationalinsurance") { IsClustered = true}));