How can I order a column in Linq where that column is a string?

Question

I have an index which from a dictionary get the column string to order by in Linq

dict.Add(0, "seleccionado");
dict.Add(1, "IdPedido");
dict.Add(2, "FechaPedido");
dict.Add(3, "NSerie");
dict.Add(4, "Importe");

I have, too, a list of Orders and I need to get the order (DESC/ASC) when I click in the column of the field.

Mmy idea was to do the Linq in one line because I will pass two parameters: the string field to order and the direction (ASC/DESC).

How can I do it in Linq?

WHAT I TRIED:

pedidos.OrderBy(x => x.seleccionado);

seleccionado is the object of the class, but in my case I will give an string instead of the object field name.

I answered in the same question – Dave Aug 06 '14 at 14:00 — Dave, Aug 06 '14 at 14:00
Did you search before? – Only a Curious Mind Aug 06 '14 at 14:14 — Only a Curious Mind, Aug 06 '14 at 14:14

score 3 · Accepted Answer · answered Aug 06 '14 at 14:04

3

If I understand the question, you're asking how to sort a collection by a field, where the field is chosen by the user.

In this case, why not store the lambda in the dictionary?

dict.Add(0, x => x.seleccionado);
dict.Add(1, x => x.IdPedido);

// etc.

answered Aug 06 '14 at 14:04

Roger Lipscombe

What if property types are different? – L.B Aug 06 '14 at 14:13
Prperties are dates, int and bool – Dave Aug 06 '14 at 14:17
@L.B, then store an IComparer there instead. – Roger Lipscombe Aug 06 '14 at 14:25
@RogerLipscombe I am not looking for an answer, I criticized your answer. – L.B Aug 06 '14 at 14:28

score 0 · Answer 2 · edited May 23 '17 at 12:05

0

This has been answered before.

There are dynamic linq libraries available. They will allow you to build up parts of your linq queries dynamically with strings.

edited May 23 '17 at 12:05

Community

answered Aug 06 '14 at 14:05

Dan

2 Answers2