How to insert a value in Database when using MVC identity framework in AspNetUsers Table?

Question

I want to insert a value in DB and I am using the Asp.Net Identity framework, in my Register method when a new user registers I also want to add a new Id which is client_id by default this id is not inserted by the identity framework?

if (User.IsInRole("Avanceon")) 
{
    var MaxCustomerId = db.AspNetUsers.Max(x => x.Customer_Id);
    if (ModelState.IsValid)
    {   
        var user = new ApplicationUser { UserName = model.UserName, Email = model.Email };
        var result = await UserManager.CreateAsync(user, model.Password);
        if (result.Succeeded)
        {
            // Assign Role to user Here 
            await this.UserManager.AddToRoleAsync(user.Id, model.RoleName);

            // Ends Here
            // await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false);
            ViewBag.userCreated = user.UserName + " Created Successfully";
            ViewBag.Name = new SelectList(context.Roles.ToList(), "Name", "Name");
            MaxCustomerId = MaxCustomerId + 1;
            // db.AspNetUsers.LastOrDefault().Customer_Id = MaxCustomerId;
            db.SaveChanges();
            return View();
            //return RedirectToAction("Index", "Home");
        }

        AddErrors(result);
    }
}

ViewBag.Name = new SelectList(context.Roles.ToList(), "Name", "Name");
return View(model);

There was a good series on Channel9 around customising ASP.NET Identity authentication. I think this episode is what you're after. IT is very similar to the below answer but includes the changes required on the Entity Framework end. channel9.msdn.com/Series/… — Ryan Thomas
– Ryan Thomas, Commented Jan 6, 2020 at 9:34

Reyan Chougle · Accepted Answer · 2020-01-06 09:45:25Z

2

You normally can't simply insert any data to AspNetUsers table. You'll need create a class and inherit it from IdentityUser and do the necessary changes in your class.

With code first you should create a class say ApplicationUser which inherits IdentityUser. And add the property there:

public class ApplicationUser : IdentityUser
{
    [Required]
    public string ClientID { get; set; }
}

And then target ApplicationUser (instead of IdentityUser) in your code:

var user = new ApplicationUser
{
    UserName = model.UserName,
    Email = model.Email,
    ClientID = model.ClientID,
};

Make below changes as well:

In ConfigureServices method of Startup.cs

services.AddIdentity<ApplicationUser, IdentityRole>();

In AccountController,

private readonly UserManager<ApplicationUser> _userManager;
private readonly SignInManager<ApplicationUser> _signInManager;

Add migration for this change to take effect

edited Jan 6, 2020 at 9:45

answered Jan 6, 2020 at 9:16

Reyan Chougle

5,3813 gold badges37 silver badges65 bronze badges

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

3 Comments

user11974227 Over a year ago

Hi i tried your solution but still not inserting the value???\

Reyan Chougle Over a year ago

You will need to create migration for this as well. Then it should work

DMur Over a year ago

If the user already exists and you just want to update the Client ID, what do you use instead of var user = new ApplicationUser { }; ?

Collectives™ on Stack Overflow

How to insert a value in Database when using MVC identity framework in AspNetUsers 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