I have some data coming from other tiers and it represents an EF object. When it's new, I do this:
context.AddToCustomer(mynewobject);
context.SaveChanges();
but now my data forms an existing object, so I want the context to know I want to update the data and not inserting it.
I've seen 'ApplyPropertyChanges' but I can't figure out how to use it. I've also seen people doing this:
Customer existingOne = (from n in context.Customers
where n.id = mynewobject.id select n).First()
existingOne.name = mynewobject.name
existingOne.address= mynewobject.address
context.SaveChanges();
but that seems a little odd because I have to manually set all the props AND read the entire object first.
In Entity Framework 5 this is how you go about:
/// <summary>
/// Updates an entity
/// </summary>
/// <param name="input">A entity</param>
/// <returns>The updated object</returns>
public TEntity Update(TEntity input)
{
using (var context = GetContext())
{
context.Set<TEntity>().Attach(input);
var entry = context.ChangeTracker.Entries<TEntity>().FirstOrDefault(e => e.Entity == input);
if (entry != null)
entry.State = EntityState.Modified;
context.SaveChanges();
}
return input;
}
While I question whether it's even worthwhile to "optimize" an update, you can nevertheless do what you ask. It's easier in EF 4, but also possible in EF 1. See also this article.
public static void AttachAsModified<T>(this ObjectSet<T> objectSet, T entity) where T : class
{
objectSet.Attach(entity);
objectSet.Context.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With