把下面的sql语句转换成linq语句

[wei421324]

select classifytb.name1, count(logtb.cid)
from classifytb,logtb
where classifytb.id=logtb.cid
group by classifytb.name1

classifytb表有下面的字段：
id 分类的id
name1 分类的名字
logtb表有下面的字段：
id 日志id
cid 所在分类的id

[q107770540]

var query= from c in classifytb
           join l in logtb
           on c.id equals l.cid
           group c by c.name1 into g
           select new {g.Key,cnt=g.Sum(t=>t.l.cid)};
           

[hjsmliang2008]

var Result = from A in classifytbs
                        join B in logtbs
                        on   A.id  equals  B.cid
                         group A by A.name1
                        into details
                        select new { details.Key,count=details.Count()  };

调试后的结果如下：

SELECT COUNT(*) AS [count], [t0].[name1] AS [Key]
FROM [dbo].[classifytb] AS [t0]
INNER JOIN [dbo].[logtb] AS [t1] ON [t0].[id] = [t1].[cid]
GROUP BY [t0].[name1]

[你的选择B]

[Quote=引用楼主 的回复:]
select classifytb.name1, count(logtb.cid)
from classifytb,logtb
where classifytb.id=logtb.cid
group by classifytb.name1

classifytb表有下面的字段：
id 分类的id
name1 分类的名字
logtb表有下面的字段：
id 日……
[/Quote]

var relult=from u in db.classifytb
join n in db.logtb on classifytb.id equals logtb.cid
group n by n.name1 into g
select new
{
g.key,
Count=g.count()
};

[lyh2ysy]

var items = from e in classifytb
join f in logtb on e.cid equals f.cid
into ef
from efs in ef
group efs by e.name1 into g
select new
{
key = g.key,
count = g.count()
};

[liangzhiweiaa]

var item = from e in classifytb
join l in logtb on e.id equsls l.cid
into el
from els in el
group els by efl.name1 into g
where e.id ==l.cid
select new
{
总数=g.count(l=>l.cid)
};

[zg_heng]

var result= from a in classifytb
join b in logtb
on a.id equals b.cid
group a by a.name1 into c
select new
{
c.Key,c.count()
};