How to specify a composite primary key using EFCore Code First Migrations

Question

I'm using Asp.Net Core 2.1, Mvc, c#, EF Core with Code First and Migrations.

I'm trying to build a table that has a composite primary key in the Migration.Up() method:

migrationBuilder.CreateTable(
    name: "TagValueAttributes",
    columns: table => new {
        TagValueID = table.Column<Int64>(nullable: false),
        Identifier = table.Column<string>(nullable: false, unicode: true, maxLength: 256),
        Value = table.Column<string>(nullable: true, unicode: true, maxLength: 2048)
    },
    constraints: table => {
        table.PrimaryKey(
            name: "PK_TagValueAttributes",
            columns: // what goes here???
        )
    }
);

I don't know what to specify for the columns parameter of the constraints table.PrimaryKey() call. I would like columns TagValueID, and Identifier to form the composite key.

What do I need to specify for the columns parameter?

score 27 · Accepted Answer · edited Nov 11 '20 at 09:11

27

Why do you want to put this in the Migration.Up() method ?

You can do this via the Fluent API in your DbContext by overriding OnModelCreating() method :

protected override void OnModelCreating(ModelBuilder builder)
{
    builder.Entity<TagValueAttributes>().HasKey(t => new { t.TagValueID, t.Identifier });
}

If you want tho keep this in Migration.Up() then do:

table.PrimaryKey(
    name: "PK_TagValueAttributes",
    columns: t => new { t.Identifier, t.TagValueID }
);

edited Nov 11 '20 at 09:11

LordDraagon

521
12
31

answered Aug 23 '18 at 20:45

Selmir

1,136
1
11
21

1

Thanks for your comments. However, there does not appear to be a property of `table` called `TagValueID` not one called `Identifier`. – Sam Axe Aug 23 '18 at 20:50
1

I want this in `Migration.Up()` because I'm using migrations. If I put it in `DbContext.OnModelCreating()` then I don't get to use Migrations. – Sam Axe Aug 23 '18 at 20:50
Mmmmh okay I removed this part of the answer, I'll be back to you in minutes with a solution I hope. – Selmir Aug 23 '18 at 20:55
1

You were very close. I'm going to fix your answer and accept it. – Sam Axe Aug 23 '18 at 21:06
Found the solution on my side a few seconds ago. Glad your problem was solved have a nice day. – Selmir Aug 23 '18 at 21:11

Mark Davich · Answer 2 · 2023-03-31T17:33:15.413

7

Using EF Core 7.0 you can use data annotations
https://learn.microsoft.com/en-us/ef/core/modeling/keys?tabs=data-annotations

using Microsoft.EntityFrameworkCore;

[PrimaryKey(nameof(Identifier), nameof(TagValueID))]
internal class table
{
    public Int64 Identifier { get; set; }
    public string TagValueID { get; set; }
    public string Value { get; set; }
}

edited Mar 31 '23 at 17:33

answered Dec 28 '22 at 21:59

Mark Davich

512
1
5
16

PrimaryKey is under which name space? PrimaryKeyAttribute could not be found error is throwing even using System.ComponentModel.DataAnnotations and System.ComponentModel.DataAnnotations.Schema – Zin Min Mar 04 '23 at 17:28
@ZinMin, the only namespace I am using is `Microsoft.EntityFrameworkCore`. Again, Microsoft introduced the **PrimaryKey** attribute in EF Core 7.0 (https://learn.microsoft.com/en-us/ef/core/modeling/keys?tabs=data-annotations#configuring-a-primary-key) – Mark Davich Mar 20 '23 at 22:17
@ZinMin Took me a moment time to find it, but you have to install the Microsoft.EntityFrameworkCore.Abstractions package to use it. – Byte Mar 30 '23 at 19:50

How to specify a composite primary key using EFCore Code First Migrations

2 Answers2