Updating identity table aspnetuser in mvc web application

Question

I am using asp.net identity for signup and signin for email confirmation i am using my own code but on email confirmation i want to update the records in aspnetuser table like emailconfirmed field to true , but it is not updating and db.savechanges()>0 always false check the below code. public JsonResult RegisterConfirm( string regId) { OurHealthisWealthEntities db = new OurHealthisWealthEntities(); var userList = UserManager.Users.Where(x=>x.Id==regId).FirstOrDefault(); userList.EmailConfirmed = true ; userList.PhoneNumber = "123123123123" ; //db.Entry(userList).State = EntityState.Modified; if (db.SaveChanges()>0) { var msg = "Your Email Is Verified!" ; return Json(msg, JsonRequestBehavior.AllowGet); } else { var msg = "your email is not verified!" ; return Json(msg, JsonRequestBehavior.AllowGet); } } Even committed line when uncomment it still not updating the record

Mark Tabor · Answer

UserManager.Update(user); this above line update the table successfully :) ??

Mark Tabor · Answer

Vinay Singh by that way it is not showing syntax error db.Entry(user).State = EntityState.Modified; but you are saying user.state which is not available , db.Entry(user).State = EntityState.Modified; it get struck when this like execute it did not throw any error nor it moves next

Vinay Singh · Answer

if state property is not available the how u r going to update email verification status

Mark Tabor · Answer

user.State this is not available after typing user and then . there is no state property

Vinay Singh · Answer

Hi Try with this. check whether it works for you ... user.State = EntityState.Modified; if (db.SaveChanges()>0) { var msg = "Your Email Is Verified!" ; return Json(msg, JsonRequestBehavior.AllowGet); } I am assumong EntityState is an Enum I used to do this when ever i modify any entity. After this just call the save function of entity

Jignesh Kumar · Answer

Hi Mark, Tyr as this link, pass full class in parameter and then try that will work. https://stackoverflow.com/questions/8056761/context-savechanges-not-working

Mark Tabor · Answer

my data is coming

Mark Tabor · Answer

Jignesh Kumar I have data in the table and var userList = UserManager.Users.Where(x=>x.Id==regId).FirstOrDefault(); this row find the record as well but when i am updating emailconfirmed field it is not getting updated , and when i am using this var selectedUser = db.AspNetUsers.Where(x => x.Id == regId).FirstOrDefault(); row the code did not execute completelt it just stop with no result. My db context class is below public partial class OurHealthisWealthEntities : DbContext { public OurHealthisWealthEntities() : base("name=OurHealthisWealthEntities") { } protected override void OnModelCreating(DbModelBuilder modelBuilder) { throw new UnintentionalCodeFirstException(); } public virtual DbSet Users { get; set; } public virtual DbSet AspNetUsers { get; set; } } and my records are saving in aspnetuser table not in user table , var userList = UserManager.Users.Where(x=>x.Id==regId).FirstOrDefault(); this line gets data from which table?

Vinay Singh · Answer

As expecting u r using entity framework. follow the link and check the sample code StudentManagerEntitie objentity = new StudentManagerEntitie(); StudentDetail objdstudent = objentity.StudentDetails.First(m => m.Id == Id); objdstudent.Name = objstudentlistmodel.StudentListDetail.Name; objdstudent.Address = objstudentlistmodel.StudentListDetail.Address; objdstudent.Maks = objstudentlistmodel.StudentListDetail.Marks; objdstudent.Section = objstudentlistmodel.StudentListDetail.Section; /*Save data to database*/ objentity.SaveChanges(); http://www.aspdotnet-pools.com/2014/08/insert-update-delete-operation-in.html

Jignesh Kumar · Answer

Hi Mark Tabor, Check you regId parameter what data you are getting. After run query on your usertable in sql server and check for same regId you have user for same id. Basically you do not have user in table I guess. Please check on that area. public JsonResult RegisterConfirm( string regId) { OurHealthisWealthEntities db = new OurHealthisWealthEntities(); var userList = UserManager.Users.Where(x=>x.Id==regId).FirstOrDefault(); if (userList != null ) { userList.EmailConfirmed = true ; userList.PhoneNumber = "123123123123" ; db.Entry(userList).State = EntityState.Modified; if (db.SaveChanges()>0) { var msg = "Your Email Is Verified!" ; return Json(msg, JsonRequestBehavior.AllowGet); } else { var msg = "your email is not verified!" ; return Json(msg, JsonRequestBehavior.AllowGet); } } }

Mark Tabor · Answer

Hi Vinay Singh thanks for the response , basically my this line var userList = UserManager.Users.Where(x=>x.Id==regId).FirstOrDefault(); is not getting data from aspnetuser table i want to get data from aspnetuser table when i write that below line the code gets struck and nothing happends var selectedUser = db.AspNetUsers.Where(x => x.Id == regId).FirstOrDefault(); how to find a user from aspnetuser table by passing userid as parameters.

Vinay Singh · Answer

Hi just pass every value of the entity table object and then save the entity. check the link also https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/updating-related-data-with-the-entity-framework-in-an-asp-net-mvc-application

Updating identity table aspnetuser in mvc web application

Answers (12)