Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

update disconnected object in entity framework

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.

like image 497
Michel Avatar asked Nov 11 '09 13:11

Michel


2 Answers

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;
        }
like image 134
Andreas Avatar answered Sep 22 '22 15:09

Andreas


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);
}
like image 33
Craig Stuntz Avatar answered Sep 22 '22 15:09

Craig Stuntz