Updating identity table aspnetuser in mvc web application

Mark Tabor

6y2.7k.NET

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

12 Replies

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

Mark Tabor6y ago
UserManager.Update(user);

this above line update the table successfully :)
??
Mark Tabor6y ago
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 Singh6y ago
if state property is not available the how u r going to update email verification status
Mark Tabor6y ago
user.State this is not available after typing user and then . there is no state property
Vinay Singh6y ago
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 Kumar6y ago
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 Tabor6y ago
my data is coming
Mark Tabor6y ago
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 Singh6y ago
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 Kumar6y ago
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 Tabor6y ago
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 Singh6y ago
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

??

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 ,

Vinay Singh thanks for the response , basically my this line