Set values with a Linq-Query?

Question

In my application I have a list of items I need to sort by price and set a rank/position index for each item. I need to store the rank because the price may change afterward. At the moment I am doing it like this:

var sortedlistKFZ = from res in listKFZ orderby res.Price select res; if (sortedlistKFZ.Any()) { int rankPosition = 1; foreach (Result kfz in sortedlistKFZ) { kfz.MesaAdvertNumber = rankPosition; rankPosition++; } }

Is there a shorter way to do it?

David Hedlund · Accepted Answer · 2009-11-20 15:33:00Z

9

Might this work?

int rankPosition = 1; var sortedListKFZ = listKFZ.OrderBy(r => r.Price).Select(r => { r.MesaAdvertNumber = ++rankPosition; return r; });

answered Nov 20, 2009 at 15:33

David Hedlund

130k33 gold badges205 silver badges223 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Jonáš Over a year ago

It will, except for one small detail ... the numbering will start from 2. You need change increment to postfix (rankPosition++) or initial value of rankPosition to 0.

user110714 · Accepted Answer · 2009-11-21 16:01:59Z

You could do it using the let keyword. This should work...

Int32[] numbers = new Int32[] { 3, 6, 4, 7, 2, 8, 9, 1, 2, 9, 4 }; int count = 1; var ranked = from n in numbers let x = count++ select new { Rank = x, Number = n };

queen3 · Accepted Answer · 2009-11-20 15:30:15Z

The simplest one would be

(from res in listKFZ orderby res.Price select res).ToList().ForEach(...)

Of course you can write your own ForEach extension for IEnumerable but I remember I had side-effect with it. It's better to operate on List.

Collectives™ on Stack Overflow

Set values with a Linq-Query?

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related