Blazor Server验证中如何结合数据库实现数据唯一性校验

因为特性验证无法注入DbContext，没法直接访问数据库，所以得用异步验证或支持依赖注入的验证框架，以下是几个实用的实现方式：

1. 实现自定义异步验证器（IAsyncValidator） #

Blazor支持异步验证接口IAsyncValidator，你可以创建一个实现该接口的验证类，通过构造函数注入DbContext，在验证逻辑里查询数据库判断值是否已存在。

示例代码：

public class UniqueEmailValidator : IAsyncValidator
{
    private readonly AppDbContext _dbContext;

    public UniqueEmailValidator(AppDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public async Task<IEnumerable<ValidationMessage>> ValidateAsync(ValidationContext context)
    {
        var email = context.PropertyValue as string;
        if (string.IsNullOrEmpty(email))
            return Enumerable.Empty<ValidationMessage>();

        var exists = await _dbContext.Users.AnyAsync(u => u.Email == email);
        if (exists)
        {
            return new[] { new ValidationMessage("该邮箱已被注册") };
        }

        return Enumerable.Empty<ValidationMessage>();
    }

    public IEnumerable<ValidationMessage> Validate(ValidationContext context)
    {
        // 同步验证留空，我们用异步逻辑
        return Enumerable.Empty<ValidationMessage>();
    }
}

然后在组件里引用这个验证器：

<EditForm Model="@UserModel" OnValidSubmit="@HandleSubmit">
    <DataAnnotationsValidator />
    <UniqueEmailValidator /> <!-- 引用自定义验证器 -->
    <InputText @bind-Value="@UserModel.Email" />
    <ValidationMessage For="@(() => UserModel.Email)" />
    <button type="submit">提交</button>
</EditForm>

@code {
    private UserModel UserModel { get; set; } = new();
    [Inject] private AppDbContext DbContext { get; set; }

    private async Task HandleSubmit()
    {
        // 提交逻辑
    }
}

2. 利用EditContext的FieldChanged事件手动验证 #

在组件中订阅EditContext的FieldChanged事件，当目标字段发生变化时，异步查询数据库，手动添加或移除验证消息。

示例代码：

<EditForm EditContext="@_editContext" OnValidSubmit="@HandleSubmit">
    <DataAnnotationsValidator />
    <InputText @bind-Value="@UserModel.Email" />
    <ValidationMessage For="@(() => UserModel.Email)" />
    <button type="submit">提交</button>
</EditForm>

@code {
    private UserModel UserModel { get; set; } = new();
    private EditContext _editContext;
    [Inject] private AppDbContext DbContext { get; set; }
    private CancellationTokenSource _debounceCts;

    protected override void OnInitialized()
    {
        _editContext = new EditContext(UserModel);
        _editContext.FieldChanged += OnFieldChanged;
    }

    private async void OnFieldChanged(object sender, FieldChangedEventArgs e)
    {
        // 只监听目标字段的变化
        if (e.FieldIdentifier.FieldName != nameof(UserModel.Email))
            return;

        // 防抖处理，避免输入过程中频繁请求数据库
        _debounceCts?.Cancel();
        _debounceCts = new CancellationTokenSource();

        try
        {
            await Task.Delay(500, _debounceCts.Token);
            var email = UserModel.Email;
            var exists = await DbContext.Users.AnyAsync(u => u.Email == email);

            var messages = _editContext.GetValidationMessages(e.FieldIdentifier);
            if (exists)
            {
                if (!messages.Any(m => m == "该邮箱已被注册"))
                {
                    _editContext.AddValidationMessage(e.FieldIdentifier, "该邮箱已被注册");
                }
            }
            else
            {
                _editContext.RemoveValidationMessages(e.FieldIdentifier, m => m == "该邮箱已被注册");
            }

            // 通知UI更新验证状态
            _editContext.NotifyValidationStateChanged();
        }
        catch (OperationCanceledException)
        {
            // 防抖取消，忽略
        }
    }

    private async Task HandleSubmit()
    {
        // 提交逻辑
    }
}

3. 使用FluentValidation集成验证 #

FluentValidation支持依赖注入，可以在验证规则中直接注入DbContext，非常适合这种需要访问数据库的验证场景。

步骤：

1. 安装NuGet包：FluentValidation.AspNetCore 和 FluentValidation.Blazor
2. 创建验证器类，注入DbContext并添加唯一性规则：

public class UserModelValidator : AbstractValidator<UserModel>
{
    private readonly AppDbContext _dbContext;

    public UserModelValidator(AppDbContext dbContext)
    {
        _dbContext = dbContext;

        RuleFor(x => x.Email)
            .NotEmpty().WithMessage("邮箱不能为空")
            .EmailAddress().WithMessage("请输入有效的邮箱格式")
            .MustAsync(async (email, cancellation) => 
                !await _dbContext.Users.AnyAsync(u => u.Email == email, cancellation))
            .WithMessage("该邮箱已被注册");
    }
}

3. 在Program.cs中注册验证器：

builder.Services.AddValidatorsFromAssemblyContaining<UserModelValidator>();

4. 在Blazor组件中使用FluentValidationValidator：

<EditForm Model="@UserModel" OnValidSubmit="@HandleSubmit">
    <FluentValidationValidator /> <!-- 使用FluentValidation验证 -->
    <InputText @bind-Value="@UserModel.Email" />
    <ValidationMessage For="@(() => UserModel.Email)" />
    <button type="submit">提交</button>
</EditForm>

@code {
    private UserModel UserModel { get; set; } = new();

    private async Task HandleSubmit()
    {
        // 提交逻辑
    }
}

以上三种方案都能解决你的问题，其中FluentValidation的方式最简洁易维护，推荐优先考虑；如果不想引入第三方库，自定义异步验证器或FieldChanged事件监听的方式也能满足需求。

内容的提问来源于stack exchange，提问作者sam