bulk insert using EntityFramework-Plus

Question

I was planning to use EntityFramework-Plus for bulk operations however i am not sure if it supports bulk insert.

So for example, i have Parent entities and i want to insert Child entities in bulk how do i dot that using EF Plus

In code below number of parents could be between 1000-2000 range and number of children are 10-20. I want to add same children for each parent, if condition satisfies

public async Task AddChildern(IEnumerable<Child> children)
{
    var ids =  GetIDs();
    var result = _dbContext.Parent.Where(x=> ids.contains(x.ID)).ToListAsync();
   foreach(var p in result)
   {
         foreach(var child in children)
         {
               var flag = CanAddChild(child);
               if(flag)
               {
                    p.Children.Add(child);
               }
         }
   }
}

@johnatan Magnan why haven't you added batch insert to EFPlus though??? it doesn't make any sense (since I don't tend to install EF Extensions) — Code_Worm, Jun 27 '18 at 07:46

Jonathan Magnan · Answer 1 · 2017-09-18T20:08:44.533

Disclaimer: I'm the owner of the project Entity Framework Plus

This library doesn't support BulkInsert.

Disclaimer: I'm the owner of the project Entity Framework Extensions

This library supports BulkInsert but it's not free.

(EF Plus is powered by this library)

In your scenario, since it looks child entity doesn't have a direct relation to the parent (No navigation property or parent ID), you should use the BulkSaveChanges method.

public async Task AddChildern(IEnumerable<Child> children)
{
    var ids =  GetIDs();
    var result = _dbContext.Parent.Where(x=> ids.contains(x.ID)).ToListAsync();
    foreach(var p in result)
    {
         foreach(var child in children)
         {
               var flag = CanAddChild(child);
               if(flag)
               {
                    p.Children.Add(child);
               }
         }
    }
}

// ...code... 

_dbContext.BulkSaveChanges();

EDIT: Answer Comment

Child does have ParentID

Depending on how the relation is set, you could also do a direct BulkInsert.

_dbContext.BulkInsert(result.SelectMany(x => x.Children));

bulk insert using EntityFramework-Plus

1 Answers1