在EF 6中选择最小值()和其他列，并按两列选择GroupBy

var result = from entity in dbContext.TableName
             group entity by new { entity.Column1, entity.Column2 } into grouped
             select new
             {
                 Column1 = grouped.Key.Column1,
                 Column2 = grouped.Key.Column2,
                 MinValue = grouped.Min(e => e.Column3),
                 OtherColumns = grouped.Select(e => e.Column4)
             };

var result = dbContext.TableName
    .GroupBy(entity => new { entity.Column1, entity.Column2 })
    .Select(grouped => new
    {
        Column1 = grouped.Key.Column1,
        Column2 = grouped.Key.Column2,
        MinValue = grouped.Min(e => e.Column3),
        OtherColumns = grouped.Select(e => e.Column4)
    });