Entity Framework 6 migrations : create index with include columns code first

Question

I'm looking for a way to create an index like this with Entity Framework 6.1:

 CREATE INDEX [IX_MYINDEX] ON [db].[dbo].[Payments] ([IsDeleted])
 INCLUDE ([Id], [InvoiceId], [OrderId])

I've found several other answers saying it can't be done because of the "Include" columns, but all of those answers are from 3 years ago so I wonder if something has been added that would make this into a possibility.

We'd like to avoid (if at all possible) to have real SQL in our code and prefer a real code-first solution where we annotate the Model-classes. I've tried Googling for it and I've spent some time reading different answers on Stackoverflow but can't seem to find the right fit. Can anyone point me in the right direction please?

Thank you very much

I have exactly the same question and preference (have data annotations populate all SQL) and was wondering if there is an update (2018) Because I could not find it in any docs (yet). — JP Hellemons
– JP Hellemons, Commented Jan 26, 2018 at 10:14
I also have the same question. It is now April 2019. I'm using EF6 and EF Core (different projects). — Paul Meems
– Paul Meems, Commented Apr 10, 2019 at 7:16

ErikEJ · Accepted Answer · 2017-06-01 13:15:05Z

4

No, still not possible in EF6 and EF Core

answered Jun 1, 2017 at 13:15

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

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

Comments

Georg Patscheider · Accepted Answer · 2017-06-01 09:53:24Z

-1

Not sure if this can be done with data annotations, but you can create an EF migration:

CreateIndex("dbo.Payments", new[] {"IsDeleted", "Id", "InvoiceId", "OrderId"}, name: "IX_MYINDEX");

answered Jun 1, 2017 at 9:53

Georg Patscheider

9,4911 gold badge28 silver badges37 bronze badges

2 Comments

Ivan Stoev Over a year ago

Well, this is just a multi column index which can be created with annotations. OP is asking for index on IsDeleted column including (but not indexing) some other columns, which is different.

Georg Patscheider Over a year ago

OK, I misunderstood the question.

Collectives™ on Stack Overflow

Entity Framework 6 migrations : create index with include columns code first

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related