How do I define an index for ASP.NET Core using EF?

Question

I'm using EF.Core in an ASP.NET core project. I have a model class, but can't find any documentation about what attributes to set on a property or the class to create an index or a unique index. Is this possible?

Morphed · Accepted Answer · 2018-11-09 15:43:41Z

3

This is currently not supported in EF core (at least not yet). I believe this is in the pipeline to be a standard annotation instead of a separate downloadable package. You can use the fluent API instead:

protected override void OnModelCreating(ModelBuilder builder)
{
    builder.Entity<User>()
        .HasIndex(u => u.EmailAddress).Unique();
}

edited Nov 9, 2018 at 15:43

Morphed

3,6292 gold badges32 silver badges59 bronze badges

answered Nov 14, 2016 at 14:28

alltej

7,39311 gold badges57 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Martin Braun Over a year ago

API has changed a little, now its .HasIndex(o => o. EmailAddress).IsUnique(true);.

Karthic G Over a year ago

do you know any idea on how to transform these by roslyn api

Alexan · Accepted Answer · 2016-11-14 04:57:48Z

0

According to documentation:

Indexes can not be created using data annotations.

But, you can use the Fluent API for this purpose.

edited Nov 14, 2016 at 4:57

answered Nov 14, 2016 at 4:26

Alexan

8,71514 gold badges83 silver badges107 bronze badges

Collectives™ on Stack Overflow

How do I define an index for ASP.NET Core using EF?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related