Linq to SQL匹配索赔类型和索赔值列表

// 定义实体类
[Table(Name = "Claims")]
public class Claim
{
    [Column(Name = "ClaimType")]
    public string ClaimType { get; set; }

    [Column(Name = "ClaimValue")]
    public string ClaimValue { get; set; }
}

// 创建数据上下文
public class DataContext : DataContext
{
    public Table<Claim> Claims { get; set; }

    public DataContext(string connectionString) : base(connectionString) { }
}

// 查询匹配的索赔类型和索赔值列表
public List<Claim> GetMatchingClaims(string claimType, List<string> claimValues)
{
    using (var context = new DataContext("connectionString"))
    {
        var matchingClaims = from claim in context.Claims
                             where claim.ClaimType == claimType && claimValues.Contains(claim.ClaimValue)
                             select claim;

        return matchingClaims.ToList();
    }
}