Search code examples
c#databasemigratordotnet

How do you add indexes to databases with MigratorDotNet?

Can someone point me in the right direction for creating indexes when using MigratorDotNet?

I have some tables which need multi column indexes.

Thanks

Solution

  • As of 0.8, it doesn't look like it's possible. A patch for adding multi-columned indexes was submitted sometime back in 2009, but it hasn't been accepted yet.

    The code to do this can be found here. I'd post a complete snipped from the patch, but I'm not sure what kind of licensing issues you or anyone else that's reading this answer might face by looking at MPL code.