Entity Framework Extensions Bulk Insert and duplicate records

Question

I'm having a problem bulk inserting data using EF Extensions library by ZZZ Projects that the records should be unique for specific tables (lookup tables) and I'm importing files to the database so the records can be repeated, I can't find a way to make the library ignore existing data

I'm not sure which options to use when bulk inserting records that can exist multiple times.

Edney Holder · Accepted Answer · 2020-06-06 04:37:03Z

2

You need the InsertIfNotExists option like below. The ColumnPrimaryKeyExpression is miss named. It can be any field in your data that you want unique.

await dbContext
    .BulkInsertAsync(sourceFiles, options =>
    {
        options.BatchSize = BatchSize;
        options.AutoMapOutputDirection = false;
        options.InsertIfNotExists = true;
        options.InsertKeepIdentity = false;
        options.ColumnPrimaryKeyExpression = sf => new { sf.<YourUniqueField>};
    })
    .ConfigureAwait(false);

answered Jun 6, 2020 at 4:37

Edney Holder

1,2409 silver badges22 bronze badges

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

2 Comments

Mohamed Said Over a year ago

the insert if not exists is set to true yet I keep getting the same error "Violation of PRIMARY KEY constraint ''. Cannot insert duplicate key in object ''. The duplicate key value is.

h3n Over a year ago

does this check the items that haven't saved yet?

Hesam Akbari · Accepted Answer · 2020-06-06 06:05:57Z

0

You can use " options.InsertIfNotExists = true; " As below:

context.BulkInsert(customers, options => { 
    options.InsertIfNotExists = true;
    options.PrimaryKeyExpression = customer => customer.Code;
  });

The options parameter let you use a lambda expression to customize the way entities are inserted

I suggest visiting entityframeworkExtensions

answered Jun 6, 2020 at 6:05

Hesam Akbari

1,1711 gold badge7 silver badges15 bronze badges

1 Comment

Mohamed Said Over a year ago

I've added that as well and the library insists on adding the records, what I'm trying to avoid is adding records that are already in the database.

Collectives™ on Stack Overflow

Entity Framework Extensions Bulk Insert and duplicate records

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related