求一linq语句

[马少华]

表ta
ID Name Atext

表tb
AID CID

表tc
ID Ctext


sql语句如下：
select ta.*,count(ta.Name) as NameCount,tc.Ctext from ta join tb on ta.ID=tb.AID join tc on tc.ID=tb.CID
where tc.Ctext = strMyCondition
group by ta.Name,ta.ID,ta.Atext,tc.Ctext
这个问题折磨了我一个晚上。

[马少华]

[Quote=引用 1 楼 的回复:]

http://www.cnblogs.com/ASPNET2008/archive/2008/12/21/1358152.html
[/Quote]
看过了，还不是很明白

[bdmh]

http://www.cnblogs.com/ASPNET2008/archive/2008/12/21/1358152.html

[threenewbee]

var query = from a in db.ta
            join b in db.tb on ta.id equals tb.id into j
            where j.ctext == strMyCondition
            group j by new { j.name, j.id, j.atext, j.ctext } into g
            select new { g, NameCount = g.Count() };

[马少华]

[Quote=引用 2 楼 的回复:]

C# code
var query = from a in db.ta
join b in db.tb on ta.id equals tb.id into j
where j.ctext == strMyCondition
group j by new { j.name, j.id, j.atext, j.ctext }……
[/Quote]
哥们儿，我这是三表连接

[threenewbee]

var query = from a in db.ta
            join b in db.tb on ta.id equals tb.id into j1
            join c in db.tc on tc.id equals j1.cid into j
            where j.ctext == strMyCondition
            group j by new { j.name, j.id, j.atext, j.ctext } into g
            select new { g, NameCount = g.Count() };

[threenewbee]

var query = from a in db.ta
            join b in db.tb on ta.id equals tb.id into j1
            join c in db.tc on tc.id equals j1.cid into j
            where j.ctext == strMyCondition
            group j by new { j.name, j.id, j.atext, j.ctext } into g
            select new { g.First(), NameCount = g.Count() };

[马少华]

[Quote=引用 4 楼 的回复:]

C# code
var query = from a in db.ta
join b in db.tb on ta.id equals tb.id into j1
join c in db.tc on tc.id equals j1.cid into j
where j.ctext == strMyCondition
……
[/Quote]
不知道你测试过没有，
join c in db.tc on tc.id equals j1.cid into j
j1里面没有ta的字段