General information
Category:
Entity Framework
Environment versions
Network:
Windows 2003 Server
>>>>Hi everybody,
>>>>
>>>>I did a quick research in Google and found that if we want to update multiple rows, we would need to loop through each row and update separately. I just want to make sure it's true and this is what I need.
>>>
>>>If I understand correctly, if there are 100 items in your collection, this will fire 100 UPDATE statements back to the database. Am I correct?
...
>I'm know you know this - it's very sad if indeed EF doesn't support table types. TTs were implemented in SQL 2008. I think nearly seven years is enough time. :)
>Actually, if you were using pure ADO.NET, you can pass a datatable to a proc and do the UPDATE in one DML statement.
>If EF can't do this, I think it's pretty unfortunate.
I had read in Screppas book that there are different method signatures for update, dataset and datatable amongst them.
But as he always was big on only updating only changed rows I guessed even the methods working on more than rows would work via chatty implementation sending N update statements. Have you checked the logs/wire if a table is sent in 1 msg in such a datatable update, and if so, is it a pruned table including only changes?
curious
thomas
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only