问Linq根据输入的最新日期获取一组值的最新记录

EN

Context.Table
    .Where(x => x.Col1 == col1 && vals.Contains(x.Col2))
    .GroupBy(x => x.Col2)
    // order by descending on the group
    // and then take the first
    .Select(grp => grp.OrderByDescending(x => x.DateEntered).First())
    .ToList();

List<int> vals = new List<int>{1, 2, 3, 4, 5};

var ans = Context.Table.Where(x => x.Col1 == Col1 && vals.Contains(x.Col2))
                       .GroupBy(x => x.Col2)
                       .Select(xg => xg.OrderByDescending(x => x.DateEntered).First())
                       .ToList();

var checkIn = iclock_transaction
               .Where(x => x.punch_state == "0" )
               // .AsEnumerable()
               .GroupBy(x=>new { x.emp_code,x.punch_time.Date })
               // order by descending on the group
               // and then take the first
               .Select(grp => grp.OrderBy(x => x.punch_time).First())
               .ToList();

//********* Perfectly work with check out   ********
var checkOut = iclock_transaction
               .Where(x => x.punch_state == "1")
               // .AsEnumerable()
               .GroupBy(x => x.emp_code)
               // order by descending on the group
               // and then take the first
               .Select(grp => grp.OrderByDescending(x => x.punch_time).First())
               .ToList();

iclock_transaction = checkIn.Concat(checkOut).ToList();