ASP.NET Core无主键表阿拉伯姓名重复插入及识别方案咨询

一、防止重复记录插入 #

针对无主键的表，从数据库约束和代码逻辑两层兜底，避免重复插入：

• 数据库层面：添加组合唯一约束
  直接针对名字、姓氏、父亲姓名三列创建组合唯一约束，数据库会直接拦截完全重复的插入请求。在EF Core中用Fluent API配置：

  protected override void OnModelCreating(ModelBuilder modelBuilder)
  {
      modelBuilder.Entity<YourTableName>()
          .HasIndex(e => new { e.FirstName, e.LastName, e.FatherName })
          .IsUnique();
  }
  

  执行迁移后，数据库会生成对应唯一索引。插入重复数据时会抛出DbUpdateException，可在代码中捕获并返回用户提示。

• 代码层面：插入前检查（结合并发处理）
  为避免不必要的异常，插入前先查询是否存在匹配记录，同时用事务包裹查询与插入操作，处理并发场景：

  using var transaction = await _dbContext.Database.BeginTransactionAsync();
  try
  {
      var normalizedFirstName = ArabicNameNormalizer.Normalize(request.FirstName);
      var normalizedLastName = ArabicNameNormalizer.Normalize(request.LastName);
      var normalizedFatherName = ArabicNameNormalizer.Normalize(request.FatherName);
  
      var existing = await _dbContext.YourTableName
          .FirstOrDefaultAsync(e => 
              ArabicNameNormalizer.Normalize(e.FirstName) == normalizedFirstName &&
              ArabicNameNormalizer.Normalize(e.LastName) == normalizedLastName &&
              ArabicNameNormalizer.Normalize(e.FatherName) == normalizedFatherName);
  
      if (existing == null)
      {
          var newRecord = new YourTableName
          {
              FirstName = request.FirstName,
              LastName = request.LastName,
              FatherName = request.FatherName
          };
          _dbContext.YourTableName.Add(newRecord);
          await _dbContext.SaveChangesAsync();
          await transaction.CommitAsync();
      }
  }
  catch (DbUpdateException ex)
  {
      await transaction.RollbackAsync();
      // 处理重复插入逻辑，如返回"记录已存在"提示
  }
  

二、识别写法不同但语义相同的阿拉伯姓名 #

阿拉伯语的变音符号（Tashkeel）、连写字符差异会导致==无法匹配，核心解决思路是标准化字符串：

实现阿拉伯语姓名标准化 #

编写辅助方法，去除变音符号并统一字符编码：

using System.Globalization;
using System.Text;

public static class ArabicNameNormalizer
{
    public static string Normalize(string name)
    {
        if (string.IsNullOrWhiteSpace(name))
            return string.Empty;

        // 分解字符与变音符号
        var normalized = name.Normalize(NormalizationForm.FormD);
        var sb = new StringBuilder();

        foreach (char c in normalized)
        {
            // 过滤掉非间距标记（即变音符号）
            if (CharUnicodeInfo.GetUnicodeCategory(c) != UnicodeCategory.NonSpacingMark)
            {
                sb.Append(c);
            }
        }

        // 重新合成为标准形式，统一字符编码
        return sb.ToString().Normalize(NormalizationForm.FormC);
    }
}

标准化的优化用法 #

为提升查询性能，建议在表中添加三个标准化字段（如NormalizedFirstName、NormalizedLastName、NormalizedFatherName），插入/更新时自动存储标准化后的姓名，再给这三个字段加组合唯一约束：

// 实体类添加标准化字段
public class YourTableName
{
    private string _firstName;
    public string FirstName
    {
        get => _firstName;
        set
        {
            _firstName = value;
            NormalizedFirstName = ArabicNameNormalizer.Normalize(value);
        }
    }

    private string _lastName;
    public string LastName
    {
        get => _lastName;
        set
        {
            _lastName = value;
            NormalizedLastName = ArabicNameNormalizer.Normalize(value);
        }
    }

    private string _fatherName;
    public string FatherName
    {
        get => _fatherName;
        set
        {
            _fatherName = value;
            NormalizedFatherName = ArabicNameNormalizer.Normalize(value);
        }
    }

    public string NormalizedFirstName { get; private set; }
    public string NormalizedLastName { get; private set; }
    public string NormalizedFatherName { get; private set; }
}

// EF Core配置标准化字段的唯一约束
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<YourTableName>()
        .HasIndex(e => new { e.NormalizedFirstName, e.NormalizedLastName, e.NormalizedFatherName })
        .IsUnique();
}

后续查询或插入检查时，直接用标准化字段匹配即可，无需实时处理原字符串。

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