How to update an object using Entity Framework

Question

I am able to add data, but not sure how should I update the data. I am getting AddObject,DeleteObject methods not found any method to update.

Thanks

Femaref · Accepted Answer · 2012-03-07 15:41:18Z

5

You simply grab an (or multiple) object(s), manipulate them and call SaveChanges on the context. Of course, the object has to be attached to the context and tracking must enabled.

var obj = context.table.First(o => o.ID == 1);
obj.Property1 = data;
context.SaveChanges();

edited Mar 7, 2012 at 15:41

answered Aug 7, 2010 at 13:07

Femaref

61.5k8 gold badges145 silver badges176 bronze badges

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

4 Comments

BreakHead Over a year ago

Thanks for reply I tried this but not working Investor inv = context.Investors.First(i => i.InvestorId == new Guid(investorId)); if (inv != null) { inv.InvestorName = tbInvestorName.Value; context.SaveChanges(); }

BreakHead Over a year ago

Hey Sorry My Mistake it was some diferent error..Thanks its working

E-A Over a year ago

Gives "The changes to the database were committed successfully, but an error occurred while updating the object context. The ObjectContext might be in an inconsistent state. Inner exception message: A referential integrity constraint violation occurred: The property values that define the referential constraints are not consistent between principal and dependent objects in the relationship." error

Femaref Over a year ago

Crystal Balling: The property you are changing has a key relationship with another model, but you aren't changing that model with the same value.

Ashraf Alam · Accepted Answer · 2011-03-19 18:43:03Z

5

Taken from Employee Info Starter Kit, you can consider the code snippet as below:

public void UpdateEmployee(Employee updatedEmployee)
        {
            //attaching and making ready for parsistance
            if (updatedEmployee.EntityState == EntityState.Detached)
                _DatabaseContext.Employees.Attach(updatedEmployee);
            _DatabaseContext.ObjectStateManager.ChangeObjectState(updatedEmployee, System.Data.EntityState.Modified);
            _DatabaseContext.SaveChanges();
        }

answered Mar 19, 2011 at 18:43

Ashraf Alam

3,66036 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to update an object using Entity Framework

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related