linq 主要是通配符 *

[JIQL7836]

linq 中 如何实现 select * from a,b where a.id = b.aid
主要是通配符 *

[g_lbz]

from a1 in a
join b1 in b on a1.Id equals b1.aId
select new {a,b}

[yezie]

from a1 in a
join b1 in b on a1.id equals b1.id
select new {a1,b1}

[chengcheng1253]

[Quote=引用 3 楼 yezie 的回复:]
from a1 in a
join b1 in b on a1.id equals b1.id
select new {a1,b1}
[/Quote]

正解

[fendouaj]

这样的
var query=(from a1 in a
from b1 in b
where a1.id == b1.id
select new {a1,b1})

去除重复取出列表数据：query=query.Distinct().ToList();

[huminghua]

[Quote=引用 3 楼 yezie 的回复:]

from a1 in a
join b1 in b on a1.id equals b1.id
select new {a1,b1}
[/Quote]正解。。