linq to sql查询问题

[【Help】]

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后，就点不出来对象了，大神帮忙看看哪里写的有问题？

[【Help】]

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;
            }

[【Help】]

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;
            }

注释那块有问题

[q107770540]

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;
            }

[q107770540]

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;
            }

[【Help】]

引用 4 楼 q107770540 的回复:

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;
            }

非常感谢