LINQ unable to update Record. it is

Question

var exist = db.Registration.FirstOrDefault(x => x.MOBILENUMBER == mobilenumber && x.EMAIL == email ); return exist; while updating the record i need to check mobilenumbaer and email. with same id. unable to update please help me out. ex : id =280 mnumber :9876545 name:David id =281 mnumber:890765 name:johnson updating id=280 if i update name it is not getting updated it saying mobile number already exist.

Sachin Singh · Answer

I guess that instead of update you are adding the details causing the duplicate issue, instead try this var user= db.Registration.FirstOrDefault(x => x.MOBILENUMBER == mobilenumber && x.EMAIL == email ); user.Name= "UpdatedName" ; db.Entry(user).state= EntityState.Modified; db.SaveChanges();

sankeerth m · Answer

Now i am updating the name but i am given 7386743523 number to first record it should not update. but if i am updating the name for id 1 it is checking this 7600000321 it is throwing duplicate. it should show through duplicate right. i need ah ;linq query please

Jignesh Kumar · Answer

Hi Sreekanth, Follow this thread, https://entityframework.net/knowledge-base/20832684/update-records-using-linq

Salman Beg · Answer

Did you apply savechanges() or submitchanges() after update record? See this link for example, https://www.codeproject.com/Articles/46422/A-LINQ-Tutorial-Adding-Updating-Deleting-Data https://stackoverflow.com/questions/20832684/update-records-using-linq/20832835

Jignesh Kumar · Answer

Above code return true or false. Where is code for update. ? After updating values you have to apply Context.SaveChanges();