Linq to entity update query not updating the table

Question

Its just a simple Linq to Entity update query i tried with the following code but it doesn't update the "User" column in the DB.

Its not even throwing any exception also,please some one point me what am missing here.

MyEntities db = new MyEntities ();

var query = from SEVTs in db.SEVTs
            where SESID == "4747747"
            select SEVTs;

foreach (var SEVTs in query) {
  SEVTs.USER = "Test";
}

db.SaveChanges();

Quite interesting, when i try the follwing query in the sql server its not update the record

update Schedwin.SEVT  
set
USER3='Test'
Where
SESID='4747747' // here i pass the value as a string

SESID data type is CHAR and its a primary key. if i pass the value as SESID=4747747 then it update that record.

Please ignore my question.

Here what i missed my input value SESID == "4747747" //this have whitespace that's why it didn't updated that particular record.

Thanks All

Gert Arnold · Accepted Answer · 2013-02-13 08:05:18Z

2

You are nor modifying SEVTs.USER, but some local variable.

(BTW: create a context in a using construct)

answered Feb 13, 2013 at 8:05

Gert Arnold

110k36 gold badges219 silver badges319 bronze badges

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

3 Comments

Usher Over a year ago

,thanks for that comment,my bad i forgot to include SEVTs.User="test" in the code above, updated my question,sorry.I will definitely going to use "using".Thanks for the suggestion.

Gert Arnold Over a year ago

Then it is very likely that it updates a different database than the one you're looking at.

Usher Over a year ago

Here what i missed, my input value SESID == "4747747" //this have whitespace that's why it didn't updated that particular record.

Collectives™ on Stack Overflow

Linq to entity update query not updating the table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related