如何在将RegularExpressionAttribute用于.Net时将CsvHelper用于属性

Install-Package CsvHelper

using System.ComponentModel.DataAnnotations;

public class MyClass
{
    [RegularExpression(@"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$", ErrorMessage = "Invalid email")]
    public string Email { get; set; }
}

using CsvHelper;
using System.Collections.Generic;
using System.IO;

public class MyClass
{
    [RegularExpression(@"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$", ErrorMessage = "Invalid email")]
    public string Email { get; set; }
}

public class Program
{
    static void Main()
    {
        using (var reader = new StreamReader("path/to/your/file.csv"))
        using (var csv = new CsvReader(reader))
        {
            var records = csv.GetRecords<MyClass>();
            foreach (var record in records)
            {
                if (!IsValid(record))
                {
                    // 处理无效数据
                }
            }
        }
    }

    static bool IsValid(object obj)
    {
        var context = new ValidationContext(obj, serviceProvider: null, items: null);
        var results = new List<ValidationResult>();

        return Validator.TryValidateObject(obj, context, results, true);
    }
}