How to customize foreign key column name using Entity Framework Code-first

Question

I have the following model

public class Foo
{
    public int Id { get; set; }
    public IList<Bar> Bars { get; set; }
}

public class Bar
{
    public int Id { get; set; }
}

When I generate the database schema from this using EF Code first it creates the following tables:

Foo

Id (PK, int, not null)

Bar

Id (PK, int, not null)
Foo_Id (FK, int null)

Is it possible to change the name of the Foo_Id foreign key using attributes?

EDIT: Here is the version that does what I need:

public class Foo
{
    public int Id { get; set; }

    [ForeignKey("AssignedToBarId")]
    public IList<Bar> Bars { get; set; }
}

public class Bar
{
    public int AssignedToBarId { get; set; }
    public int Id { get; set; }
}

Kamyar · Accepted Answer · 2011-04-18 09:42:34Z

8

I think it can be done like below:

~~protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity.Map(c => c.MapKey(u => u.Id, "AssignedToBarID")); }~~

Or maybe:

[ForeignKey("AssignedToBarID")]
public IList<Bar> Bars { get; set; }

NOTE: I have not tested neither of them. These are just suggestions.

edited Apr 18, 2011 at 9:42

answered Apr 18, 2011 at 9:20

Kamyar

18.8k9 gold badges101 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Wheelie Over a year ago

Thanks, your second option did the trick! (must remember to add a property on the Bar type called AssignedToBarId for this to work)

an phu Over a year ago

This is a good solution if you don't need bi-directional navigation. NOTE: The name, AssignedToBarID, is a bit confusing for me; AssignedToFooID would be more illustrative.

Collectives™ on Stack Overflow

How to customize foreign key column name using Entity Framework Code-first

Foo

Bar

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Foo

Bar

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related