Batch CUD support
When SaveChanges is called, rather than sending one SQL statement per insert/update/delete, batch it all up into one SQL statement
6 comments
-
Ruwan Wijesinghe
commented
It is ideal if you can support bulk updates and deletes like below,
query.Update(entity => new { prop1 = 10, prop2 = entity.prop2 + 10});
query.Delete(); -
van
commented
Bulks Insert/Update/Delete is a real performance problem in EF seeing as there is no real support for bulk. This is my most needed feature right now.
Even if the entity model supported the DBType.Structured it would help a lot. Then you would be able to pass a data table to a stored proc. But at the moment you have to create a new SqlConnection to do this, which is not cool. -
Roger Hendriks
commented
Also support bulk update and delete from code
-
machi_pon
commented
-
alaa9jo
commented
also we want it to support conditional update/delete,i.e.:
UPDATE TableName
SET Column1 = ‘Value’
WHERE AnotherColumn = ‘AnotherValue’ -
Djoul6
commented
And why not use bulk bind to increase performances ?