Avoid switch case -linq

Question

Possible Duplicate:
Dynamic LINQ OrderBy

  switch (sort) {
                case "Title":
                    queryResults = queryResults.OrderBy(r => r.Title);
                    break;
                default:
                    queryResults = queryResults.OrderBy(r => r.LastName);
                    break;

Is there any way I can get rid of the switch block above?

Can I do some thing like:

queryResults = queryResults.OrderBy(r => r."sort");
or
queryResults = queryResults.OrderBy(r => r.sort);

You'll find your answer in this question: http://stackoverflow.com/questions/41244/dynamic-linq-orderby — web_bod, May 22 '12 at 12:42
The solutions provided won't work for most linq providers, please see my solution: http://stackoverflow.com/a/21936366/775114 — Mark Powell, Feb 21 '14 at 13:59

score 8 · Accepted Answer · answered May 22 '12 at 12:33

If you wanted to do this completely dynamic, you could use some reflection (simple example):

string prop = "Title";
var q = queryResults.OrderBy(x => x.GetType().GetProperty(prop).GetValue(x, null));

I wouldn't consider this the nicest solution in any case though. Whether this really makes sense for you depends on where you get the property name from (if you get it from reflection, too, or not) and how many properties there are.

score 5 · Answer 2 · answered May 22 '12 at 12:35

5

This should do it

queryResults = queryResults.OrderBy(r => sort == "Title" ? r.Title : r.LastName)

answered May 22 '12 at 12:35

Jan Aagaard

10,940
8
45
80

score 4 · Answer 3 · answered May 22 '12 at 12:41

4

You could use DynamcLinq. I haven't touched it in over a year, but I had the expected results. Your code would change to:

queryResults = queryResults.OrderBy(sort);

Oh cool, it's also a NuGet package too

answered May 22 '12 at 12:41

Marc

9,254
2
29
31

Avoid switch case -linq

3 Answers3