Is it possible to create an index using Entity Framework Code First Migrations in an MS SQL Server database if the index needs to be:
It must result in the following:
CREATE NONCLUSTERED INDEX [IX_IndexName] ON [dbo].[TableName] ( [Column1] ASC, [Column2] DESC ) INCLUDE ([Column3], [Column4])
On this subject, I discovered in a piece, however it provides a somewhat laborious solution. It's possible that anything has changed since the article was written.
Although I am aware that I can force my migration to run any SQL code, I really want to be able to use any variant of
instead of writing SQL code myself, I can use a technique that handles all the grunt work for me.