如何将AspNetUsers与另一个表连接？

public class ApplicationUser : IdentityUser
{
    // 添加外键列
    public int UserProfileId { get; set; }
    public virtual UserProfile UserProfile { get; set; }
}

public class UserProfile
{
    public int Id { get; set; }
    // 其他属性
}

// 在DbContext中配置关联
protected override void OnModelCreating(ModelBuilder builder)
{
    base.OnModelCreating(builder);

    builder.Entity<ApplicationUser>()
        .HasOne(u => u.UserProfile)
        .WithOne()
        .HasForeignKey<ApplicationUser>(u => u.UserProfileId);
}

// 获取当前用户的UserProfile
var user = await _userManager.GetUserAsync(User);
var userProfile = user.UserProfile;