嵌套选择LINQ查询 [英] Nested Select linq query

问题描述

试图找出LINQ查询，并想知道，如果你们能帮助。

Trying to work out a linq query and was wondering if you guys could help.

我有对象的列表富，每个富对象栏的列表。酒吧有一个活动的日期和数值。例如：

I have a list of objects foo and each foo object has a list of bar. bar has an active date and a numeric value. for example

foo
   bar -> 01/02/05, 10000
   bar -> 04/06/10, 30023
foo
   bar -> 30/01/02, 23494

和我想写一个LINQ查询将返回我一个独特的日期的名单和总结总该日期

And I want to write a linq query that will return me a distinct list of dates and the summed total for that date

这可能是上周五，但我画一个空白。

It may be that its friday, but I'm drawing a blank.

在此先感谢

推荐答案

看起来像你想要的：

var query = from foo in list
            from bar in foo.Bars
            group bar.Value by bar.Date into dates
            select new { Date = dates.Key, Sum = dates.Sum() };

这篇关于嵌套选择LINQ查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！