Entity Framework Code First Update by Stub Entity

Question

Is it possible in EF Code-First to update without querying the entire row in db by using stub objects,...

e.g.

public class Dinner 
{     
    public int DinnerID { get; set; }     
    public string Title { get; set; }     
    public DateTime EventDate { get; set; }     
    public string Address { get; set; }     
    public string Country { get; set; }     
    public string HostedBy { get; set; }       
}



Dinner dinner = dinner.DinnerID = 1;     
dinner.HostedBy = "NameChanged" 
nerdDinners.SaveChanges();

will the code above create an Update Statement which will make the following columns null for the row of DinnerID 1 ?

Title, EventDate, Address, Country

Is there a way or method like "PropertyModified" = true, then the rest make them = false, so that HostedBy is the only one that will be updated?

Daniel Revell · Accepted Answer · 2012-01-25 09:44:24Z

4

I think you are looking for ApplyCurrentValues

public void UpdateDinner(Dinner existingDinner)
{
    var stub = new Dinner { DinnerId = existingDinner.DinnerId };
    ctx.Dinners.Attach(stub);
    ctx.ApplyCurrentValues(existingDinner);
    ctx.SaveChanges();
}

ApplyCurrentValues copies the scalar values from the existing object to the object in the graph (in the above case - the stub entity).

From the Remarks section on MSDN:

Any values that differ from the original values of the object are marked as modified.

Is that what your after?

edited Jan 25, 2012 at 9:44

Daniel Revell

8,63614 gold badges61 silver badges98 bronze badges

answered Dec 15, 2010 at 10:07

RPM1984

73.3k62 gold badges241 silver badges364 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shawn Mclean Over a year ago

Why cant I find ApplyCurrentValues()? method does not exist.

Jon · Accepted Answer · 2011-06-21 21:58:23Z

1

To build on Paul's answer, the following will work when you are using EF Model or Database First:

context.ObjectStateManager.GetObjectStateEntry(dinner).SetModifiedProperty("HostedBy");

answered Jun 21, 2011 at 21:58

Jon

4,9453 gold badges30 silver badges38 bronze badges

Comments

CD.. · Accepted Answer · 2010-12-15 09:49:14Z

0

I think you are looking for the Attach() method.

Attaching and Detaching Objects

edited Dec 15, 2010 at 9:49

answered Dec 15, 2010 at 9:44

CD..

74.3k25 gold badges160 silver badges170 bronze badges

Comments

Paul · Accepted Answer · 2011-02-03 21:02:36Z

Try this maybe, it is specific to EF Code First which seems to do it differently than just EF.

var dinner = context.Dinners.Find(1);

context.Entry(dinner).Property(d => d.HostedBy).IsModified = true;

context.SaveChanges();

From ADO.NET team blog

"Marking a property as modified forces an update to be send to the database for the property when SaveChanges is called even if the current value of the property is the same as its original value."

Collectives™ on Stack Overflow

Entity Framework Code First Update by Stub Entity

4 Answers 4

1 Comment

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Linked

Related