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

Entity Framework 6.1 Code First migration error: EntityType 'IdentityUserRole' has no key defined

I created a new MVC 5 project and I tried to enable migrations for the Code First entities I've been creating, when I got the following PS exceptions in the Package Manager Console:...One or more validation errors were detected during model generation: Project.Web.Models.IdentityUserRole: : EntityType 'IdentityUserRole' has no key defined. Define ...

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

I want to implement versioning on my entity ...Stuff.... Each entity has an optional reference to the next version (the latest version will be null) and an optional reference to the previous version (the first version will be null). I am using entity framework 6, code first. I tried with the following model and modelbuilder statement (and many vari...

primary key constraint updating many-to-many self referential table in entity framework code-first

Found the problem....On the initial load of the entity, I was using an include statement to eager load the children....When I updated the entity, when I fetched it from the db again, I did not eager load the children. Therefore the additions/updates were getting confused. Once I put the include in during the upload Scenario #2 above worked (the exp...

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);

EntityType has no key defined error despite defining key

I just encountered this problem. I tried adding ...[Key]..., I used ...public string Id { get; set; }.... Ultimately the fix was that I just needed to rebuild my project. I wanted to leave this answer here just in case someone in the future was having this issue.

Defining Self Referencing Foreign-Key-Relationship Using Entity Framework 7 Code First

You are not modeling correctly your entity. Each comment needs a ...Set... of replies, which are of type ArticleComment too, and each of those replies are the ones that point back to its parent (Note the added ...ICollection Replies property...):... public class ArticleComment { public ArticleComment() { Replies = ...

Can EF7 Create non-clustered primary key?

You can do it in Entity Framework Core Code First by ovveriding OnModelCreating in DbContext... p.HasKey(b => b.ColumnId).ForSqlServerIsClustered(false); ...This will generate migration like this:... table.PrimaryKey("PK_Columns", x => x.ColumnId) .Annotation("SqlServer:Clustered", false);

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)] ...

Create a non-clustered index in Entity Framework Core

Using Entity Framework Core, I want to have a Guid PK, without suffering page ...fragmentation... in the database....I have seen this ...post... and ...this.... Although it was possible in EF6, the way it's done seems to have changed....Is it possible to create a non-clustered primary key in Entity Framework Core and have an additional index?...Q&A...

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...