tags:

views:

69

answers:

1
Q: 

How to update a single field using EF4

I want to update a single field in my table for a particular row. I am using Entity Framework 4 and Visual Studio 2010.

Options I can think of are:

  • Using a Stored Procedure
  • Direct connection to the database and using sql statement

I am not aware of any more efficient method to perform this task.

[EDIT]
I would like to do the update in the same operation as the Get for that row, so that it is done in one DB call.

+1  A: 

No need to complicate things. Just change the one property and SaveChanges. Unless you're doing something odd, that should only change the one column. Look at the SQL to verify.

Craig Stuntz  2010-05-20 15:34:42
Very good point, but how do I do it in the same operation as the Get call? I want to limit the DB call.
Picflight  2010-05-20 15:42:48
This sounds like a premature optimization to me.
Craig Stuntz  2010-05-20 16:07:02
"premature optimization," means to me that I should not worry about one call to DB right now, make it work and look at optimization at a later stage of development.
Picflight  2010-05-20 19:05:34
Almost. It means optimize the slowest part of your app (I'm betting this is not it), not look later.
Craig Stuntz  2010-05-20 19:45:52

related questions

Best method of profiling Entity Framework 4 dynamic queries?
Unique Keys not recognized by Entity Framework
caching problem in entity framework 4
Inserting an entity related to another using POCOs with EF
one-to-one relationships in Entity Framework 4 v2 with POCO
'Generic' ViewModel
named connection not found (Entity framework problem)
Using ADO.net Entity Framework 4 with Enumerations? How do I do it ?
Entity Framework 4.0: Why Would One Use the Code Generated EntityObjects Over POCO Objects?
Retrieve only base class from Entity Framework
EF4 POCO - Updating a navigation property
Using an Interface with a navigation property
EF4 POCO one to many Navigation property is null
Silverlight 4.0 + MVC 2.0 + WCF RIA Services + EF 4.0 = Load Error
How can I add constraints to an ADO.NET Entity?
Entity Splitting with Code Only
Using sql date data type and EF4
Table per hierarchy inheritance with POCO entities in Entity Framework 4
Is there any way to install EF4 on VS2008 SP1?
RIA services, EF and stored procs
Mocking Entity Context in EF4
Entity Framework 4 Multiple Object Delete(RemoveAll)
Exclude a field/property from the database with Entity Framework 4 & Code Only
.NET 4.0 CTP and EF CTP - is it good enough for production code?
Selecting particlar fields with EF4.0