Linq to Sql 实现矩阵
0
悬赏园豆：10
[待解决问题]
| TableA | TableB | TableC | |||||
| Name | Name | NameA | NameB | ||||
| A001 | B001 | A001 | B001 | ||||
| A002 | B002 | A001 | B002 | ||||
| A003 | B003 | A002 | B003 | ||||
| B004 | A003 | B004 | |||||
上面三个表如何通过Ling to sql 实现如下的查询结果
| B001 | B002 | B003 | B004 | |||
| A001 | 1 | 1 | 0 | 0 | ||
| A002 | 0 | 0 | 1 | 0 | ||
| A003 | 0 | 0 | 0 | 1 | ||
