Cannot insert duplicate key in object - How to create composite key in Entity Framework Core

c# entity-framework entity-framework-core sql sql-server

Question

I have a requirement to create composite key using Entity Framework Core

This is my class

public partial class MasterType
{
    [DataMember(Name = "Id")]
    [Key]
    public string Id { get; set; }

    [Required]
    [DataMember(Name = "Name")]
    [Key]
    public string Name { get; set; }
}

Here is my Configuration class, which help me to create composite properties

public class MasterTypeConfigurations : BaseEntityConfigurations<MasterType>
{
    public override void Configure(EntityTypeBuilder<MasterType> builder)
    {
       base.Configure(builder); 
       // composite key
       builder.HasKey(c => new { c.Id, c.Name});
    }
}

I am using migration feature of entity framework core

Here is the generated migration script

  migrationBuilder.CreateTable(
            name: "MasterTypes",
            columns: table => new
            {
                Id = table.Column<string>(nullable: false),
                Name = table.Column<string>(nullable: false)
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_MasterTypes", x => new { x.Id, x.Name });                 
            });

But, when I execute the insert SQL, I get error 

 INSERT INTO [dbo].[MasterTypes] ([Id] ,[Name]) VALUES  ('CA8301','Type1')
 INSERT INTO [dbo].[MasterTypes] ([Id] ,[Name]) VALUES  ('CA8301','Type2')

Cannot insert duplicate key in object. The duplicate key value is (C8301, C8301).

Why it's not combining the Name. Because Name is uniqie

1
1
2/22/2019 7:05:50 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The tutorial required on this link is available :Composite Keys

Entity Framework Core supports composite keys - primary key values generated from two or more fields in the database. However, unlike in previous versions of Entity Framework, you cannot use the Key attribute to define composite keys. This can only be done via the Fluent API. 

class Program
{
    static void Main(string[] args)
    {
        using (var db=new SampleContext())
        {
            db.Database.EnsureCreated();
            db.MasterTypes.Add(new MasterType()
            {
                Id = "CA8301",
                Name = "Type1"
            });
            db.MasterTypes.Add(new MasterType()
            {
                Id = "CA8301",
                Name = "Type2"
            });
            db.SaveChanges();
        }
    }
}

public class SampleContext : DbContext
{
    public DbSet<MasterType> MasterTypes { get; set; }
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<MasterType>()
            .HasKey(o => new { o.Id, o.Name});
    }
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("Server=.;Database=MyDb;Trusted_Connection=True;");
    }
}

public class MasterType
{
    public string Id { get; set; }
    public string Name { get; set; }
}

The table is designed according to your request:

design of table

the data based on your question:

enter image description here

1
2/22/2019 9:12:26 AM

Related Questions

EntityFramework - Composite Key Table with FK to another Composite Key Table

I've ...two tables... both with ...composite primary keys.... ...Both... have in common ...one of the primary key's with a foreign key... to another table....The problem is that when i create the migrations, it messes up the foreign keys....I must use data annotations....Example:...public class City { [Key, Column(Order = 1)] [DatabaseGener...
asp.net-mvc-5 composite-primary-key entity-framework entity-framework-6 foreign-key-relationship
asked by Leandro Soares

EF 6.1.3 - Cannot insert duplicate key in object

I searched on site for solving my problem, but I still haven't solved it. I have 2 entities:...public class Article { [Key] public Guid ID { get; set; } public Guid? ApprovedBy_ID { get; set; } public Guid CreatedBy_ID { get; set; } public virtual Profile ApprovedBy { get; set; } public virtual Profile CreatedBy { get; set; ...
asp.net entity-framework entity-framework-6
asked by Nhật Quang

Composite key Entity Framework 7 "The Property Cannot Be added to Entity Type

I'm trying to make a enitity that manages membership of a user in a organization with a role. I want to restrict a user to have only one membership in an organization. I'm doing this by creating a composite key. However i get the error when i try to create the initial migrations: ...InvalidOperationException: The property 'User' cannot be added to ...
c# entity-framework entity-framework-core
asked by Kracobsen

Creating composite primary key consisting off foreign keys in fluent API with ASP.NET core

The question here is how can i generate a composite primary key consisting of two foreign keys? ...I have tried: ...public class ActiveQuestions_Questions { [Column(Order = 0), Key, ForeignKey("ActiveQuestion")] public string ActiveQuestionId {get; set;} [Column(Order = 1), Key, ForeignKey("Question")] public string QuestionId {ge...
c# entity-framework-core
asked by Nyranith

Many-to-many relationship in Entity Framework Core when one entity has composite primary key

I have the following classes:...public class InvoiceLine { public Guid Id { get; set; } public int LineNumber { get; set; } public List<ProductCode> ProductCodes { get; set; } } public class ProductCode { public string Category { get; set; } public string Value { get; set; } } ...In the case of ...ProductCode... the ....
.net-core c# entity-framework entity-framework-core
asked by user2024449

EF core: cannot insert object with foreign key using ID properties (only navigation properties work)

I'm using Entity Framework Core to create my (code first) database model.... In the model I have these classes:...[Table("groups")] public class Group { public int? Id { get; set; } [JsonIgnore] public virtual ICollection<Membership> Members { get; set; } } [Table("identities")] public class Identity { public int? Id { get; set; } ...
c# entity-framework-core
asked by Paolo Tedesco

Microsoft Entity Framework Core: Cannot insert duplicate key in object

I am trying to update a parent entity, GuildMemberTeam, with child entities, GuildMember, Team and GuildMemberChallenge which also has a child entities, GuildMember and Challenge but am getting the following inner exception:...Inner Exception 1: SqlException: Violation of PRIMARY KEY constraint 'PK_Challenge'. Cannot insert duplicate key in objec...
c# entity-framework-core sql
asked by mat_e3

Entity Framework Core: Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

I am getting the following error when inserting records into a child table, Why is Entity Framework Core trying to insert a record into the parent table(IdentityUser table) when I am asking it to insert a record into a child table(Keywords table)? ...StackTrace:...An unhandled exception occurred while processing the request. SqlException: Violation...
asp.net-core c# entity-framework entity-framework-core
asked by Ajit Goel

ASP.NET EF CORE: Composite key composed of two foreign keys not evaluating properly

EDIT... After some editing I am now able to post the data but have issues scaffolding the structure. My model builder feels like it's better now but something is still amiss...modelBuilder.Entity<Client>().HasMany(x => x.Machines).WithOne(x=>x.Client).HasForeignKey(x=>x.ClientID); modelBuilder.Entity<Machine>().HasKey(x => new { x.ID, x.ClientID })...
asp.net-core c# entity-framework-core sql
asked by Donar144

How to change single primary key to composite primary key with EF Core

I want to delete the single primary key Id column in a SQL table that has already been created and does not contain data and define a composite primary key instead....My current entity definition is as follows:...[Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public long IpFrom { get; set; } public long Ip...
.net .net-core c# entity-framework entity-framework-core
asked by Umut Gür

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