質問編集履歴
1
検証コード追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -38,5 +38,41 @@
|
|
|
38
38
|
[試したこと]
|
|
39
39
|
SharpDevelopで変換→正常に変換できず
|
|
40
40
|
|
|
41
|
+
下記のコードを実行したが、「'join' は無効です。」のエラーが出ました。
|
|
42
|
+
|
|
43
|
+
```ここに言語を入力
|
|
44
|
+
var result = from u in context.Users
|
|
45
|
+
join contact in context.Emergency_contacts
|
|
46
|
+
on u.user_id equals contact.user_id
|
|
47
|
+
join user_name in context.User_names
|
|
48
|
+
on u.user_id equals user_name.user_id
|
|
49
|
+
group join depart_user in context.User_Departments
|
|
50
|
+
on u.user_id equals depart_user.user_id
|
|
51
|
+
into deptab = group
|
|
52
|
+
from departGroup in deptab.DefaultIfEmpty()
|
|
53
|
+
where departGroup is null
|
|
54
|
+
order by u.user_code
|
|
55
|
+
select new UserCsvEntity
|
|
56
|
+
{
|
|
57
|
+
user_id = u.user_id,
|
|
58
|
+
user_id_hash = u.user_id_hash,
|
|
59
|
+
user_code = u.user_code,
|
|
60
|
+
mail_address = u.mail_address,
|
|
61
|
+
shimei = user_name.shimei,
|
|
62
|
+
kana_shimei = user_name.kana_shimei,
|
|
63
|
+
kana_tsusho = user_name.kana_tsusho,
|
|
64
|
+
tsusho = user_name.tsusho,
|
|
65
|
+
mail_address1 = contact.mail_address1,
|
|
66
|
+
mail_address2 = contact.mail_address2,
|
|
67
|
+
mail_address3 = contact.mail_address3,
|
|
68
|
+
tel_no1 = contact.tel_no1,
|
|
69
|
+
tel_no2 = contact.tel_no2,
|
|
70
|
+
tel_no3 = contact.tel_no3,
|
|
71
|
+
dept_admin = listCerId.Contains(u.user_id) ? "1" : "",
|
|
72
|
+
system_admin = listSysAdId.Contains(u.user_id) ? "1" : "",
|
|
73
|
+
dept_cd = ""
|
|
74
|
+
};
|
|
75
|
+
```
|
|
76
|
+
|
|
41
77
|
[環境]
|
|
42
78
|
Visual Studio 2017
|