ADO.NET Entity Model Update

Question

Hi i am trying to update a record from the database, but for some reason the record is not updated. I am using ADO.NET entity Framework 4.0

public void updateCredits(string username)
 {
     myDBEntities Entity = new myDBEntities();
     User u = Entity.Users.SingleOrDefault(u => u.username == username)
     u.firstname = "name";
     u.credits = 11.5;
     Entity.SaveChanges();
 }

I tried restarting VS and even the SQL Server but no luck. Am i doing something wrong?

There's nothing wrong with your code -- there's obviously more to this issue than the actual code you've displayed. — George Johnston
– George Johnston, Commented Apr 13, 2013 at 18:28

w.brian · Accepted Answer · 2013-04-13 18:35:10Z

1

It looks like there is an issue with change tracking. You can try manually marking the User entity as changed like so:

public void updateCredits(string username)
 {
     myDBEntities Entity = new myDBEntities();
     User u = Entity.Users.SingleOrDefault(u => u.username == username)
     u.firstname = "name";
     u.credits = 11.5;
     Entity.Entry(u).State = EntityState.Modified;  //<-- manually indicate the entity was changed
     Entity.SaveChanges();
 }

If the above code works, then there's a good chance ChangeTracking is being disabled somehow.

answered Apr 13, 2013 at 18:35

w.brian

17.7k14 gold badges77 silver badges127 bronze badges

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

1 Comment

comb Over a year ago

thank you brian for your fast reply. I managed to solve the problem by removing all the tables from the ADO.NET Entity and adding them again. :) Thanks

Collectives™ on Stack Overflow

ADO.NET Entity Model Update

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related