Question

I have 2 columns Name and Amount

我和林克一样,根据谁拥有最大数额,将姓名归还。

迄今为止,我有:

    string name = (from nm in bg
           select nm.Name).Max(Amount);

这显然不会奏效。

谢谢。

Answer 1

string name = (from nm in bg
               where nm.Amount == bg.Max(i=>i.Amount)
           select nm.Name)

或

string name = (from nm in bg
               orderby nm.Amount desc
           select nm.Name).First()

Answer 2

快速办法我可以这样认为(最后数额,然后找到最多、两条方式的物品,并且是O(n)):

decimal amount = bg.Max(x=>x.Amount);
var name = bg.First(x=>x.Amount == amount).Name; // O(n)

也可以:

// O(n^2) in worst case, O(n) in best case
bg.First(x=>x.Amount == bg.Max(x=>x.Amount)).Name;

或

bg.OrderByDescending(x=>x.Amount).First().Name; // O(n log n) in all situation

Answer 3

表达

bg.OrderByDescending(nm => nm.Amount).First().Name

将获得你想要的东西,但如果<条码>bg是空洞的话,就会扔 throw。如果这是一个问题,使用

var topNm = bg.OrderByDescending(nm => nm.Amount).FirstOrDefault();

www.un.org/spanish/ga/president