LINQ unable to update Record. it is

sankeerth m

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Hi Sreekanth,

Follow this thread,
https://entityframework.net/knowledge-base/20832684/update-records-using-linq
+2
Sachin Singh5y ago
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();
+2
sankeerth m5y ago

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
+2
Salman Beg5y ago
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
+2
Jignesh Kumar5y ago
Above code return true or false. Where is code for update. ?

After updating values you have to apply

Context.SaveChanges();
+2