8,497
社区成员
发帖
与我相关
我的任务
分享
var query = from c in DBContext.Class
join s in DBContext.Student on c.Id equals s.ClassId into a
select new { c.Id,c.ClassName, total = a.Count() };
foreach(var item in query)
{
Console.WriteLine(string.Format("班级ID:{0},班级名称:{1},学生人数:{2}", item.Id,item.ClassName, item.total));
}
Console.ReadLine();