Entity framework and ObjectContext.SaveChanges()

Question

In datatables with ADO.NET an updatecommand updates full row.That means that even if you change 1 cell all collumns of the row would be updated... This is not the problem always.
However although reading from msdn i couldnt find whether this this true for Entity Framework. Updating a property would create a full update sql query or only for the column ?

score 1 · Accepted Answer · edited May 23 '17 at 10:34

1

According to this tested and verified answer How to update only one field using Entity Framework? only updated fields are updated in sql not the entire object.

edited May 23 '17 at 10:34

Community

1
1

answered Oct 16 '11 at 16:15

Muhammad Hasan Khan

33,784
16
85
129

score 0 · Answer 2 · answered Oct 16 '11 at 16:25

0

Hasan is correct, only changed fields are updated and this is easy to confirm by tracing the SQL in the SQL Profiler (or equivalent tool)

answered Oct 16 '11 at 16:25

E.J. Brennan

43,955
6
83
111

Entity framework and ObjectContext.SaveChanges()

2 Answers2