In Entity Framework 7 which property Attribute creates an index in code first?

data-annotations entity-framework-core

Question

In Entity Framework 7 (7.0.0-rc1-final) which property Attribute creates an index?

I would normally add an index to a sql table to improve look up times so I assume I need to specify this in my class?

public class Account
{
  [Key]
  [Required]
  public int AccountId { get; set; }

  [Required] <-- How do I make this an Index in Sql Server?
  public int ApplicationUserId { get; set; }
}

I assume [Index] would do it but this is not recognised.

How do I index the ApplicationUserId column?

1
0
12/28/2015 1:06:47 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Use the fluent API in your DbContext class:

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Account>()
            .HasIndex(b => b.ApplicationUserId);
    }
3
12/28/2015 1:13:14 PM

Popular Answer

Here is a workaround:

[AttributeUsage(AttributeTargets.Property | AttributeTargets.Field)]
    public class IndexAttribute : Attribute
    {
    }

protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
foreach (var entity in modelBuilder.Model.GetEntityTypes())
            {
                foreach (var property in entity.GetProperties())
                {
                    if (property.PropertyInfo != null && property.PropertyInfo.GetCustomAttributes<IndexAttribute>().Any())
                    {
                        entity.AddIndex(new[] { property });
                    }
                }
            }
    }
xumix

Related Questions

Entity Framework will only set related entity property to "null" if I first get the property

As a workaround, the easiest way I've found to mitigate this issue is to have the setter call the getter ...before... setting the backing field to null, e.g....public class Foo { public int? Id { get; set; } private Bar _bar; public virtual Bar { get { return _bar; } set { var entityFrameworkH...
c# entity-framework entity-framework-6
asked by Nathan

How to create index in Entity Framework 6.2 with code first

Is there a way to create an index on a property/column using code-first, instead of using the new ...IndexAttribute... ?
ef-code-first entity-framework entity-framework-6
asked by Valo

How to create Multiple one-to-one relationships in EF Code first?

For it to be (One-to-One) ...LedgerChartOfAccount... should have a primary key of ...public int CatalogoDeCuentasID {get; set;}...In the model builder your configuration should look like this: ...modelBuilder.Entity<LedgerChartOfAccount>() .HasKey(x => x.CatalogoDeCuentasID); modelBuilder.Entity<LedgerChartOfAccount>() ...
asp.net-mvc c# ef-code-first entity-framework entity-framework-6
asked by Andres Ramos

How to create an index for a string property in Entity Framework 7

Unfortunately at this time (7.0.0-beta1), the max length and column type metadata is not honored when determining which column type to use. For now, you'll have to drop down to raw DDL in the migration....// Add before CreateIndex migrationBuilder.Sql("ALTER TABLE [Keyword] ALTER COLUMN [Word] nvarchar(4000)");
entity-framework-core visual-studio-2015
asked by bricelam

Entity Framework Code First Fluent API configuration for one to one identifying relationship

I have the following class structure:...How to configure Fluent API to put identifying relationship in Cards table? ...I mean ...Cards Table PK: Id, CustomerId...Cards Table FK: CustomerId...I would like the previous Card be deleted when I assign a new one to Customer.Card property....So I defined my classes this way:...public class Customer { ...
c# code-first ef-fluent-api entity-framework entity-framework-6
asked by Dmitry Nogin

How to define a one to one self reference using Entity Framework Code First

public class Stuff { public int Id { get; set; } public int? NextVersionId { get; set; } public int? PrevVersionId { get; set; } public virtual Stuff NextVersion { get; set; } public virtual Stuff PrevVersion { get; set; } } ...Updated: ...modelBuilder.Entity<Stuff>().HasOptional(t => t.NextVersion).WithMany().HasForeignKey...
c# entity-framework entity-framework-6 foreign-keys self-reference
asked by Paul Kyrejto

How to create Indexed Views with entity framework code-first approach

There is no direct method for creating views from EF 6....You need to write raw SQL to create the view, then execute it from a dbMigration. For details see: ...https://msdn.microsoft.com/en-us/magazine/dn519921.aspx
ef-code-first entity-framework entity-framework-6 indexed-view
asked by Shiraz Bhaiji

Persisting and retrieving serialized entity property with Entity Framework 6.1 code first

Example: Let's say I have these three classes. ...Foo... is a proper Entity Framework entity with a DbSet whereas I want my EF DbContext to be unaware of ...Bar... and ...Baz... because I have flagged Foo's Bar property with my made up ...SerializedColumn... attribute. By applying that attribute, I want EF to serialize the instance of Bar with its ...
ef-code-first ef-migrations entity-framework entity-framework-6 entity-framework-6.1
asked by Jeremy Cook

One-to-One relationships in Entity Framework 7 Code First

You can define OneToOne relationship using Fluent API in Entity Framework 7 as below...class MyContext : DbContext { public DbSet<Blog> Blogs { get; set; } public DbSet<BlogImage> BlogImages { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<Blog>() .HasOne(p =...
ef-code-first ef-fluent-api entity-framework entity-framework-core
asked by Sangram More

Entity Framework Code First unique index foreign key throws DbUpdate Exception

Entity framework is re-adding your Owner(Member). There are a couple of ways around this, but since you have the FK try this:...public class Bicycle { public int BicycleID { get; set; } public int MemberID { get; set; } // You can call this ownerId, but then you need to setup the relationship with annotation or fluent public virtual M...
c# ef-code-first entity-framework entity-framework-6 foreign-key-relationship
asked by Steve Greene

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow