回答編集履歴
2
言語指定の誤りを修正
answer
CHANGED
|
@@ -1,21 +1,21 @@
|
|
|
1
|
-
`SelectMany`の代わりにクエリ構文で`from`を使うと、シンプルに書けます。
|
|
1
|
+
`SelectMany`の代わりにクエリ構文で`from`を使うと、シンプルに書けます。
|
|
2
|
-
|
|
2
|
+
|
|
3
|
-
```
|
|
3
|
+
```c#
|
|
4
|
-
var query =
|
|
4
|
+
var query =
|
|
5
|
-
from trader in traders
|
|
5
|
+
from trader in traders
|
|
6
|
-
from item in items
|
|
6
|
+
from item in items
|
|
7
|
-
where
|
|
7
|
+
where
|
|
8
|
-
trader.Id == item.Id &&
|
|
8
|
+
trader.Id == item.Id &&
|
|
9
|
-
item.ExpiryDate > new DateTime(2010, 1, 1)
|
|
9
|
+
item.ExpiryDate > new DateTime(2010, 1, 1)
|
|
10
|
-
select new {
|
|
10
|
+
select new {
|
|
11
|
-
Id = trader.Id,
|
|
11
|
+
Id = trader.Id,
|
|
12
|
-
CompanyNm = trader.CompanyNm,
|
|
12
|
+
CompanyNm = trader.CompanyNm,
|
|
13
|
-
Address = trader.Address,
|
|
13
|
+
Address = trader.Address,
|
|
14
|
-
Price = item.Price,
|
|
14
|
+
Price = item.Price,
|
|
15
|
-
ExpireDate = item.ExpiryDate
|
|
15
|
+
ExpireDate = item.ExpiryDate
|
|
16
|
-
};
|
|
16
|
+
};
|
|
17
|
-
|
|
17
|
+
|
|
18
|
-
var result = query.ToList();
|
|
18
|
+
var result = query.ToList();
|
|
19
|
-
```
|
|
19
|
+
```
|
|
20
|
-
|
|
20
|
+
|
|
21
21
|
[From … From … (SelectMany) - クエリ式の構文例:射影 - ADO.NET | Microsoft Docs](https://docs.microsoft.com/ja-jp/dotnet/framework/data/adonet/ef/language-reference/query-expression-syntax-examples-projection#from--from--selectmany)
|
1
ToListを追加
answer
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
`SelectMany`の代わりにクエリ構文で`from`を使うと、シンプルに書けます。
|
|
2
2
|
|
|
3
3
|
```lang-c#
|
|
4
|
-
var
|
|
4
|
+
var query =
|
|
5
5
|
from trader in traders
|
|
6
6
|
from item in items
|
|
7
7
|
where
|
|
@@ -15,6 +15,7 @@
|
|
|
15
15
|
ExpireDate = item.ExpiryDate
|
|
16
16
|
};
|
|
17
17
|
|
|
18
|
+
var result = query.ToList();
|
|
18
19
|
```
|
|
19
20
|
|
|
20
21
|
[From … From … (SelectMany) - クエリ式の構文例:射影 - ADO.NET | Microsoft Docs](https://docs.microsoft.com/ja-jp/dotnet/framework/data/adonet/ef/language-reference/query-expression-syntax-examples-projection#from--from--selectmany)
|