Группировка таблицы с выбором записи, соответствующей максимальному значению

static void Main(string[] args)
{
    List<Field> tbl = new List<Field>
    {
        new Field {Fldname = "F1", Version = 1},
        new Field {Fldname = "F1", Version = 2},
        new Field {Fldname = "F1", Version = 8},
        new Field {Fldname = "F2", Version = 5},
        new Field {Fldname = "F2", Version = 0},
        new Field {Fldname = "F3", Version = 6},
    };
 
    var res = from field in tbl
                group field by field.Fldname into fields
                select new Field { Fldname = fields.Key, Version = fields.Max(f => f.Version) };
 
    var res2 = tbl
        .GroupBy(f => f.Fldname)
        .Select(g => new Field() { Fldname = g.Key, Version = g.Max(f => f.Version) });
}
public class Field
{
    public string Fldname { get; set; }
    public int Version { get; set; }
}

static void Main(string[] args)
{
    var tbl = new []
    {
        new {Fldname = "F1", Fldval = "a", Version = 1},
        new {Fldname = "F1", Fldval = "g", Version = 2},
        new {Fldname = "F1", Fldval = "s", Version = 8},
        new {Fldname = "F2", Fldval = "w", Version = 5},
        new {Fldname = "F2", Fldval = "q", Version = 0},
        new {Fldname = "F3", Fldval = "n", Version = 6}
    };
 
    var res = tbl.GroupBy(t => t.Fldname)
                  .Select(g =>
                  {
                        var maxField = g.OrderBy(m => m.Version).LastOrDefault();
 
                        return new
                        {
                            Fldname = g.Key,
                            Fldval = maxField.Fldval,
                            Version = maxField.Version
                        };
                  });
}