Linq以获取具有最小列值的行，但基于另一个列值

var rows = new List<Row>
{
    new Row { Id = 1, Value = 10, Category = "A" },
    new Row { Id = 2, Value = 5, Category = "B" },
    new Row { Id = 3, Value = 8, Category = "A" },
    new Row { Id = 4, Value = 3, Category = "B" },
    new Row { Id = 5, Value = 6, Category = "A" }
};

var minRow = rows
    .Where(row => row.Category == "A") // 基于Category列值筛选
    .OrderBy(row => row.Value) // 按照Value列值升序排序
    .FirstOrDefault(); // 获取第一个符合条件的行

if (minRow != null)
{
    Console.WriteLine($"Id: {minRow.Id}, Value: {minRow.Value}, Category: {minRow.Category}");
}
else
{
    Console.WriteLine("No rows found.");
}