时间戳

首页 > 解决方案 > ASP.NET Core Identity User 如何使用外键引用自动更新表

sql - ASP.NET Core Identity User 如何使用外键引用自动更新表

问题描述

我正在做一个 ASP.NET Core MVC Web 应用程序项目。为此，我在用户注册并创建自己的帐户时使用 ASP.NET Core Identity Framework。

我的项目中有 03 个字符为common_user, business_user, customer_user. business_user 和 customer_user 继承自 common_user。

以下是我为实施该项目而设计的EER图的一部分。（我已经简化了它，只关注我关心的问题）

EER图 在此处输入图像描述

如您所见，我将03 个表创建为common_user, （我肯定需要这样做，由于某种原因，我不能将所有表都放在一个表中）business_user。customer_user我正在创建的数据库是 Microsoft SQL 数据库。

Identity User 到用户类的继承顺序如下。

我的问题：
如何在用户注册到系统后立即business_user更新cusomter_user 表格？当用户注册到系统时，“身份用户表”（common_user）被更新。但它并没有自动更新其他两个表。所以，我需要知道我该怎么做？

提前致谢。

我附上了register.cshtml和 register.cshtml.cs课程供您参考。我觉得我应该对以下代码进行一些更改，以触发 cusotmer_user 和 business_user 表中的数据存储。

注册.cshtml

@page
@model RegisterModel
@{
    ViewData["Title"] = "Register";
    Layout = "~/Areas/Identity/Pages/_AuthLayout.cshtml";
}

<div class="col-md-12 register-background">
    <form asp-route-returnUrl="@Model.ReturnUrl" method="post">
        <div asp-validation-summary="All" class="text-danger"></div>
        <div class="row input-field-style">
            <div class="col-md-6">
                <div class="form-group">
                    <div class="input-group">
                        <input asp-for="Input.FirstName" class="form-control" placeholder="First Name" />
                    </div>
                    <span asp-validation-for="Input.FirstName" class="text-danger"></span>
                </div>
            </div>
            <div class="col-md-6">
                <div class="form-group">
                    <div class="input-group">
                        <input asp-for="Input.LastNam" class="form-control" placeholder="Last Name" />
                    </div>
                    <span asp-validation-for="Input.LastNam" class="text-danger"></span>
                </div>
            </div>
        </div>
        <div class="form-group input-field-style">
            <div class="input-group">
                <input asp-for="Input.Email" class="form-control" placeholder="Email" />
            </div>
            <span asp-validation-for="Input.Email" class="text-danger"></span>
        </div>
        <div class="row input-field-style">
            <div class="col-md-6">
                <div class="form-group">
                    <div class="input-group">
                        <input asp-for="Input.Password" class="form-control" placeholder="Password" />
                    </div>
                    <span asp-validation-for="Input.Password" class="text-danger"></span>
                </div>
            </div>
            <div class="col-md-6">
                <div class="form-group">
                    <div class="input-group">
                        <input asp-for="Input.ConfirmPassword" class="form-control" placeholder="Confirm Password" />
                    </div>
                    <span asp-validation-for="Input.ConfirmPassword" class="text-danger"></span>
                </div>
            </div>
        </div>
        <button type="submit" class="btn">Register</button>
    </form>
</div>

@section Scripts {
    <partial name="_ValidationScriptsPartial" />
}

注册.cshtml.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Text.Encodings.Web;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Authentication;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.UI.Services;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.AspNetCore.WebUtilities;
using Microsoft.Extensions.Logging;
using WebProject.Models;

namespace WebProject.Areas.Identity.Pages.Account
{
    [AllowAnonymous]
    public class RegisterModel : PageModel
    {
        private readonly SignInManager<Common_user> _signInManager;
        private readonly UserManager<Common_user> _userManager;
        private readonly ILogger<RegisterModel> _logger;
        private readonly IEmailSender _emailSender;

        public RegisterModel(
            UserManager<Common_user> userManager,
            SignInManager<Common_user> signInManager,
            ILogger<RegisterModel> logger,
            IEmailSender emailSender)
        {
            _userManager = userManager;
            _signInManager = signInManager;
            _logger = logger;
            _emailSender = emailSender;
        }

        [BindProperty]
        public InputModel Input { get; set; }

        public string ReturnUrl { get; set; }

        public IList<AuthenticationScheme> ExternalLogins { get; set; }

        public class InputModel
        {
            [Required]
            [DataType(DataType.Text)]
            [Display(Name = "First Name")]
            public string FirstName { get; set; }

            [Required]
            [DataType(DataType.Text)]
            [Display(Name = "Last Name")]
            public string LastNam { get; set; }

            [Required]
            [EmailAddress]
            [Display(Name = "Email")]
            public string Email { get; set; }

            [Required]
            [StringLength(100, ErrorMessage = "The {0} must be at least {2} and at max {1} characters long.", MinimumLength = 6)]
            [DataType(DataType.Password)]
            [Display(Name = "Password")]
            public string Password { get; set; }

            [DataType(DataType.Password)]
            [Display(Name = "Confirm password")]
            [Compare("Password", ErrorMessage = "The password and confirmation password do not match.")]
            public string ConfirmPassword { get; set; }
        }

        public async Task OnGetAsync(string returnUrl = null)
        {
            ReturnUrl = returnUrl;
            ExternalLogins = (await _signInManager.GetExternalAuthenticationSchemesAsync()).ToList();
        }

        public async Task<IActionResult> OnPostAsync(string returnUrl = null)
        {
            returnUrl ??= Url.Content("~/");
            ExternalLogins = (await _signInManager.GetExternalAuthenticationSchemesAsync()).ToList();
            if (ModelState.IsValid)
            {
                var user = new Common_user { UserName = Input.Email, Email = Input.Email, FirstName = Input.FirstName, LastNam = Input.LastNam };
                var result = await _userManager.CreateAsync(user, Input.Password);
                if (result.Succeeded)
                {
                    _logger.LogInformation("User created a new account with password.");

                    var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
                    code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code));
                    var callbackUrl = Url.Page(
                        "/Account/ConfirmEmail",
                        pageHandler: null,
                        values: new { area = "Identity", userId = user.Id, code = code, returnUrl = returnUrl },
                        protocol: Request.Scheme);

                    await _emailSender.SendEmailAsync(Input.Email, "Confirm your email",
                        $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>.");

                    if (_userManager.Options.SignIn.RequireConfirmedAccount)
                    {
                        return RedirectToPage("RegisterConfirmation", new { email = Input.Email, returnUrl = returnUrl });
                    }
                    else
                    {
                        await _signInManager.SignInAsync(user, isPersistent: false);
                        return LocalRedirect(returnUrl);
                    }
                }
                foreach (var error in result.Errors)
                {
                    ModelState.AddModelError(string.Empty, error.Description);
                }
            }

            return Page();
        }
    }
}

标签： sqlasp.net-identity

解决方案

推荐阅读