复杂的 LINQ 查询

Question

考虑到这种结构...

List<IEnumerable<KeyValuePair<String, String>>>

您将如何为以下伪代码编写 LINQ 查询...

SELECT
    /* Count of how many [KeyValuePair] exists in [List] */
FROM
    [List]
WHERE
        [KeyValuePair].Key == "foo"
    AND Int32.Parse([KeyValuePair].Value.Replace(".", "")) > 10

...？

更新

上述查询的结果，根据下面的列表运行，应该是 6（六）...

var list = new List<IEnumerable<KeyValuePair<String, String>>>
{
    new []
    {
        new KeyValuePair<String, String>("foo", "1.1"),
        new KeyValuePair<String, String>("foo", "1.2"),
        new KeyValuePair<String, String>("foo", "1.3")
    },                                            

    new []                                        
    {                                             
        new KeyValuePair<String, String>("foo", "0.1"),
        new KeyValuePair<String, String>("foo", "0.2"),
        new KeyValuePair<String, String>("foo", "0.3")
    },                                            

    new []                                        
    {                                             
        new KeyValuePair<String, String>("foo", "2.1"),
        new KeyValuePair<String, String>("foo", "2.2"),
        new KeyValuePair<String, String>("foo", "2.3")
    }
};

Answer 1

我从中得到6分...

var result = list.Sum(item=>item.Count(kp=>kp.Key == "foo" && int.Parse(kp.Value.Replace(".",String.Empty))>10));

Answer 2

var result = list.SelectMany(ary =>aryx).Count(item => item.Key == "Foo" && Int32.Parse(item.Value.Replace(".", "")) > 10);

虽然我猜你正在替换“。”因为您想摆脱千位分隔符，所以您可能需要： Int32.Parse(item.Value, NumberStyles.AllowThousands, CultureInfo.CurrentCulture) 确保正确设置了当前区域性。 Strike>

为了清楚起见，我可能会这样写：

var result = list.SelectMany(ary => ary)
                 .Where(item => item.Key.Equals("Foo", StringComparison.CurrentCulture))
                 .Select(item => 
                      Int32.Parse(item.Value.Replace(".", ""))
                 .Count(value=> value> 10);

理解语法可能如下所示：

var q = from @array in list
        from kvp in array
        where kvp.Key.Equals("Foo", StringComparison.CurrentCulture)
        select .Parse(item.Value.Replace(".", ""));
var result = q.Count(value => value > 10);