主页 / user-397776

Sergey Samusik's questions

Martin Hope
Sergey Samusik
Asked: 2022-02-08 18:07:33 +0000 UTC
  • 0

我正在使用 net core 3.1 + Entity framework core。有一个 User 和 UserType 模型，我保存在数据库中。对他们来说，我使用单独的 DTO 进行创建和阅读。Dto 来到控制器，我将它映射到用户模型中。接下来，我将模型发送到数据库，保存它。然后，在控制器中，我映射回 Dto，尽管所有内容都保存到数据库中，但 ID 和用户类型并未更新。跟踪已禁用。我通过创建模型的新实例解决了控制器中的问题，但事实并非如此。

如何解决问题？

楷模：

public class User
{
    [Key]
     public int Id { get; set; }

    [Required]
    [StringLength(50, MinimumLength = 5)]
    public string Nickname { get; set; }

    [EmailAddress]
    public string Email { get; set; }

    [Phone]
    public string PhoneNumber { get; set; }

    [Required]
    [StringLength(50, MinimumLength = 5)]
    public string Password { get; set; }

    public int UserTypeId { get; set; } 

    public virtual UserType UserType { get; set; }
} 

public class UserType
{
    [Key]
    public int Id { get; set; }

    [Required]
    [StringLength(50, MinimumLength = 5)]
    public string Name { get; set; }
}

给他们 DTO 创建

public class UserCreateDto
{
    [Required(AllowEmptyStrings = false, ErrorMessage = "Nickname not specified")]
    [StringLength(50, MinimumLength = 5)]
    public string Nickname { get; set; }

    [EmailAddress]
    public string Email { get; set; }

    [Phone]
    public string PhoneNumber { get; set; }

    [Required(AllowEmptyStrings = false, ErrorMessage = "Password not specified")]
    [StringLength(50, MinimumLength = 5)]
    public string Password { get; set; }

    [Required(AllowEmptyStrings = false)]
    [Compare("Password", ErrorMessage = "Passwords don't match")]
    public string PasswordConfirm { get; set; }
}

public class UserTypeCreateDto
{
    [Required(AllowEmptyStrings = false, ErrorMessage = "User's type not specified")]
    [StringLength(50, MinimumLength = 3)]
    public string Name { get; set; }
}

和阅读

public class UserReadDto
{
    public int Id { get; set; }
    public string Nickname { get; set; }
    public string Email { get; set; }
    public string PhoneNumber { get; set; }
    public UserTypeReadDto UserType { get; set; }
}

public class UserTypeReadDto
{
    public int Id { get; set; }
    public string Name { get; set; }
}

在用户的存储库中实现该方法。已经在这里有必要返回更新的用户。否则，在控制器中，调用此方法后，数据没有更新。我没有禁用 EF Core 的跟踪，我没有调用 AsNoTracking () 方法。

public async Task<User> AddAsync(User user)
{
    var context = dbContextFactory.Create(typeof(UserRepository));

    var userTypeId = await context.UserTypes
                                  .Where(x => x.Name == "Client")
                                  .Select(x => x.Id)
                                  .FirstOrDefaultAsync();
    if (userTypeId == 0)
    {
        UserType userType = new UserType
        {
            Name = "Client"
        };

        await context.UserTypes.AddAsync(userType);
        await context.SaveChangesAsync();
 
        userTypeId = userType.Id;
    }

    User newUser = new User
    {
        Nickname = user.Nickname,
        Email = user.Email,
        PhoneNumber = user.PhoneNumber,
        Password = user.Password,
        UserTypeId = userTypeId
    };

    await context.Users.AddAsync(newUser);
    await context.SaveChangesAsync();

    return newUser;
}

和实际控制人。

[HttpPost("")]
public async Task<IActionResult> CreateUserAsync(UserCreateDto userDto)
{
    if (userDto == null || !ModelState.IsValid)
    {
        return BadRequest(ModelState);
    }

    var user = mapper.Map<User>(userDto);

    //after saving to the database(context.SaveChangesAsync()), the user model is not updated.
    //I was unable to fix this.So I do the following:
    
    var userResult = await userRepository.AddAsync(user); // get user with Id from database.

    userResult = await userRepository.GetByIdAsync(userResult.Id); // get user with userType from 
    database.

    var userReadDto = mapper.Map<UserReadDto>(userResult);

    return CreatedAtAction(nameof(GetUserByIdAsync), new { id = userReadDto.Id }, userReadDto);
}
asp.net-core