Skip to content
This repository has been archived by the owner on Sep 18, 2020. It is now read-only.

mattjohnsonpint/EntityFramework.IndexingExtensions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

EntityFramework.IndexingExtensions NuGet Version

Indexing Extensions for Entity Framework 6

Installation

PM> Install-Package EntityFramework.IndexingExtensions

Usage

public class MyDataContext : DbContext
{
  protected override void OnModelCreating(DbModelBuilder modelBuilder)
  {
    modelBuilder.Entity<Customer>()
        .HasIndex("IX_Customers_Name",          // Provide the index name.
            e => e.Property(x => x.LastName),   // Specify at least one column.
            e => e.Property(x => x.FirstName))  // Multiple columns as desired.

        .HasIndex("IX_Customers_EmailAddress",  // Supports fluent chaining for more indexes.
            IndexOptions.Unique,                // Supports flags for unique and clustered.
            e => e.Property(x => x.EmailAddress)); 
  }
}

Notes

After publishing this, I was informed that there is an active pull request here to add something similar directly into Entity Framework. If/when that is merged, you should probably use it instead. Though, this one should continue to work without issue.

About

Indexing Extensions for EF6

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages