Entity Framework Core 设置索引

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
　　　　　　　//设置父类中的索引
            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity<Book>()
                .HasIndex(p => new { p.Name })
                .IsUnique();

        }

 

specify an index over more than one column:

class MyContext : DbContext
{
    public DbSet<Person> People { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Person>()
            .HasIndex(p => new { p.FirstName, p.LastName });
    }
}