Linq 溫故知新Howard 2013/12/13

先來個問題 

  提示 SelectMany

解答

Aggregate

Aggregate - Simple

This sample uses Aggregate to create a running product on the array that calculates the total product of all elements.

Aggregate - Seed

This sample uses Aggregate to create a running account balance that subtracts each withdrawal from the initial balance of 100, as long as the balance never drops below 0.

Deferred Execution

The following sample shows how query execution is deferred until the query is enumerated at a foreach statement.

請問輸出結果是 ?

Immediate Execution

輸出結果如下，該怎麼做 ?

Query Reuse

請問輸出結果是 ?

cross join, inner join, outer join資料如下：

cross join

怎麼做 ?

inner join 怎麼做 ?

outer join 怎麼做 ?

References

http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b