batch updates using Entity Framework

Question

Can anyone suggest me how to deal with batch updates using Entity Framework?

For ex: Updating a field for a list (List) of between 100 and 1000 Id's, which the primary key. Calling each update separately seem to be to much overhead and takes a long time.

Adrian Hristov · Accepted Answer · 2014-07-03 14:17:26Z

1

Until you call SaveChanges() none of the data is updated in the database so you can make how many changes you'd like.

You can take a look at a Unit of Work design pattern if you want a more structured way of saving changes to the database.

answered Jul 3, 2014 at 14:17

Adrian Hristov

2,0452 gold badges17 silver badges22 bronze badges

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

2 Comments

Hemanth Vanal Over a year ago

Thanks for reply..But Adrian did you get my point? i know that until i call SaveChanges() nothing is updated to database. what i need all about batch update.

Adrian Hristov Over a year ago

Hi, you can check this thread out stackoverflow.com/questions/12751258/batch-update-delete-ef5 hope it answers some of your questions

Collectives™ on Stack Overflow

batch updates using Entity Framework

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related