How to insert data into multiple tables with a foreign key using EF core?

Question

What is the best way to insert data into multiple tables with one or more new rcords containing a foreign key to the first table using Entity Framework Core?

Given these entities:

public class ParentEntity
{
    public int Id {get; set;}
    public string Name {get; set;}
}

public class ChildEntity
{
    public int Id {get; set;}
    public int ParentId {get; set;}
    public string Name {get; set;}
}

I know I can insert the data using this method:

var parentEntity = new ParentEntity {Name = "Mom"};
var childEntity = new ChildEntity {Name = "Junior"};

await db.Parents.AddAsync(parentEntity);
childEntity.ParentId = parentEntity.Id;
await db.Children.AddAsync(childEntity);
await _context.SaveChangesAsync();

But I can see that this will not scale very well. I am learning EF Core right now I cannot find a better way to handle this.

Jan Paolo Go · Accepted Answer · 2019-06-12 17:04:22Z

10

If you REALLY need to just use foreign key, then that's how you should do it.. it's like doing manual SQL queries.

But EF supports the concept of a navigation property. So you can define your classes like:

public class ParentEntity
{
    public int Id {get; set;}
    public ICollection<ChildEntity> Children { get; } = new List<ChildEntity>();
}

public class ChildEntity
{
    public int Id {get; set;}
    public int ParentId {get; set;}
}

then use it like this

var parentEntity = new ParentEntity();
parentEntity.Children.Add(new ChildEntity());

context.Parents.Add(parentEntity); // parent and its children gets added
context.SaveChanges();

answered Jun 12, 2019 at 17:04

Jan Paolo Go

6,6924 gold badges30 silver badges59 bronze badges

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

Comments

tisaconundrum · Accepted Answer · 2022-04-22 04:01:04Z

0

Another way you can do this as well. In this example more emphasis is put on the Models.

public class ParentEntity
{
    public int Id {get; set;}
    public string Name {get; set;}
}

public class ChildEntity
{
    public int Id {get; set;}
    public int ParentId {get; set;}
    public virtual ParentEntity ParentEntity {get; set;}
    public string Name {get; set;}
}

And here's the usage

var parentEntity = new ParentEntity 
{
    Name = "Mom"
};

var childEntity = new ChildEntity 
{
    ParentEntity = parentEntity,
    ParentId = parentEntity.Id,
    Name = "Junior"
};

context.Add(childEntity);
context.SaveChanges();

answered Apr 22, 2022 at 4:01

tisaconundrum

2,3114 gold badges24 silver badges41 bronze badges

Collectives™ on Stack Overflow

How to insert data into multiple tables with a foreign key using EF core?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related