Non Clustered Primary Key Entity Framework Code First

entity-framework-6 indexing

Question

In Entity Framework Code First approach, can we define the Primary Key as non-clustered index and a combination of few other fields as clustered index.

Thanks

1
6
6/16/2016 9:24:18 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

EntityTypeConfiguration does not provide a means of setting the Primary Key as a non-clustered index, but you can complete this by altering the initial migration used for table creation. There is an example here.

Here is an example of how to specify a clustered multiple-column index using attributes:

[Index("IX_ColumnOneTwo", 1, IsClustered = true)]
public int ColumnOne { get; set;}

[Index("IX_ColumnOneTwo", 2, IsClustered = true)]
public int ColumnTwo { get; set; }

and an example of how to complete this using model builder:

modelBuilder.Entity<ClassOne>() 
            .Property(t => t.ColumnOne) 
            .HasColumnAnnotation( 
                     "Index",  
                     new IndexAnnotation(new IndexAttribute("IX_ColumnOneTwo") { IsClustered = true }));
modelBuilder.Entity<ClassOne>() 
            .Property(t => t.ColumnTwo) 
            .HasColumnAnnotation( 
                     "Index",  
                     new IndexAnnotation(new IndexAttribute("IX_ColumnOneTwo") { IsClustered = true }));
4
5/23/2017 11:46:34 AM

Popular Answer

EF 6.2 resolved this issue. Currently, it's in beta state, but it works.

First, upgrade your EF to 6.2:

Install-Package EntityFramework -Version 6.2.0-beta1 -Pre

Then, in the OnModelCreating method, set the IsClustered to false for the primary key:

modelBuilder.Entity<Receipt>().HasKey(r => r.RecId, config => config.IsClustered(false) );
Johnny Qian

Related Questions

Entity Framework Code First Using One column as Primary Key and another as Auto Increment Column

Apparently the ...answer... of @IronMan84 correct. But it didn't work for me. I slightly modified it to apply my another condition. And it worked. I did nothing else....This is my solution....public class Sale { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } [Key, Column(TypeName = "varchar"), MaxLeng...
c# ef-code-first entity-framework
asked by Seevali H Rathnayake

Entity Framework Foreign Key as Primary Key Code First

I have two code first models, Foo and FooState where Foo has an optional FooState....public class Foo { [Key] public int FooId { get; set; } public FooState FooState { get; set; } } public class FooState { [Key] public int FooStateId { get; set; } [Required] public int State { get; set; } [Required] public Fo...
c# ef-code-first entity-framework
asked by Neil

How to manually set entity primary key in Entity Framework code first database?

Well, I have the following model structure: I have one class - ...DatabaseEntity... which is basically ...public class DatabaseEntity { public int Id { get; set; } } ...so each entity like product, category etc will inherit ...DatabaseEntity... and have ...Id... property. Also I have typical ...EntityFramework... repository class with ...Insert...
c# entity-framework primary-key
asked by Dmytro

Entity Framework Code-First - Define the Non-clustered key for this EntityType

I Have defined an entity class with a key, but I don,t want that key be cluster because I have another cluster index in my entity, but I received an error when I add an Index attribute to my model,...Can anybody tell me that how can I define a ...Non-Clustered Key...????
ef-code-first entity-framework entity-framework-6 entity-framework-6.1
asked by Mahdi Khalili

Entity Framework 6.1.3 Mapping Foreign key to non primary key

The goal is to have an API with all the fields from the GravityZone with the name of the zone coming from the Zone table. I've tried several permutations of the following code without success. It's currently coming up with null for the Zone which I'm hoping to get either the name as a string or part of the object. I'm working with existing tables ...
c# entity-framework-6
asked by stb

create non clustered index on primary key entity framework 6.0

You can also do this with your ...OnModelCreating... method like so:...modelBuilder.Entity(entityTypeName) .HasKey(nameof(ClassName.Id)) .ForSqlServerIsClustered(false);
entity-framework entity-framework-6
asked by Tyler Findlay

Entity Framework code-first set foreign key with primary key in same table

I have this ...WdUser... class inherited from ...SysModelBase...:...[Serializable] public class WdUser : SysDomainModelBase, IWdUser { [Display(Name = "UserName")] [MaxLength(25)] [Required] public string UserName { get; set; } [Required] [Index(IsUnique = true)] [MaxLength(25)] [Display(Name = "LoginName ")] pu...
asp.net c# entity-framework-6
asked by Autyan

Mapping foreign key to non primary surrogate key column in EF code first

public class A { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Aid { get; set; } public virtual ICollection<B> B { get; set; } } public class B { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Bid { get; set; } [Key] [Column(Order = 0)] ...
c# ef-code-first entity-framework entity-framework-6 foreign-keys
asked by user5419119

One to One Relationship with Different Primary Key in EF 6.1 Code First

I am having an issue getting a reference to the employee object from the PayGroup object using Entity Framework 6.1. I have a foreign key in the database on PayGroup.SupervisorId -> Employee.EmployeeId. Note that this is a zero or one-to-one relationship (a pay group can only have one supervisor and an employee can only be the supervisor of one pay...
c# ef-fluent-api entity-framework entity-framework-6 sql-server
asked by Brian Swart

EF 6 Code-First Many to Many relationship with same entity on non-primary key

I have an EF 6 Task entity, which looks like this:...public class Task { public Guid TaskId {get; set;} public TaskTypeEnum TaskType {get; set;} public TaskStatusEnum TaskStatus {get; set;} public virtual ICollection<Task> Dependencies {get; set;} } ...Tasks of a certain type can be dependent on all other tasks of a certain type to...
.net c# database entity-framework entity-framework-6
asked by user3802230

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