linq多表查询怎么写
请问各位大侠
我有五张表A/B/C/D/E
每张表都有一个ID字段
A表的ID是A表主键和B/C/D/E表的外键
那我这几个表的连接查询要怎么写?
[解决办法]
直接根据关联做联合查询
var result = from a in A
join b in B on a.UserID equals b.UserID
join c in C on a.UserID equals c.UserID
select new {...};