62,046
社区成员
发帖
与我相关
我的任务
分享
using (Database.db.DataContext trading = new Database.db.DataContext(da.Connetion))
{
List<game> game = (from f in db.table
join g in db.Game
on f.Code equals g.Code
where f.name == Name
orderby f.Score descending
// group f by f.Code into gname
select new game
{
Name = g.Name,
Code = g.Code
}).Take(5).ToList<game>();
return game;
}
那里加了group后,就点不出来对象了,大神帮忙看看哪里写的有问题?using (Database.db.DataContext trading = new Database.db.DataContext(da.Connetion))
{
List<game> game = (from f in db.table
join g in db.Game
on f.Code equals g.Code
where f.name == Name
orderby f.Score descending
group f by f.Code into gname
select new game
{
Name = gname.First().Name,
Code = gname.Key
}).Take(5).ToList<game>();
return game;
}
using (Database.db.DataContext trading = new Database.db.DataContext(da.Connetion))
{
List<game> game = (from f in db.table
join g in db.Game
on f.Code equals g.Code
where f.name == Name
orderby f.Score descending
group f by f.Code into gname
select new game
{
Name = g.First().Name,
Code = g.Key
}).Take(5).ToList<game>();
return game;
}
using (Database.db.DataContext trading = new Database.db.DataContext(da.Connetion))
{
List<game> game = (from f in db.table
join g in db.Game
on f.Code equals g.Code
where f.name == Name
orderby f.Score descending
// group f by f.Code into gname
select new game
{
Name = g.Name,
Code = g.Code
}).Take(5).ToList<game>();
return game;
}
注释那块有问题
using (Database.db.DataContext trading = new Database.db.DataContext(da.Connetion))
{
List<game> game = (from f in db.table
join g in db.Game
on f.Code equals g.Code
where f.name == Name
orderby f.Score descending
<span style="color: #FF0000;">group f by f.Code into gname</span>
select new game
{
Name = g.Name,
Code = g.Code
}).Take(5).ToList<game>();
return game;
}