>>>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?
>
>Yes but in one transaction if we put SaveChanges at the end.

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.