How to sort a List containing ExpandoObjects

Question

I have a list which contains a dictionary of ExpandoObjects. Im binding this to a grid but now I want to sort the list.

        var rows = new List<dynamic>();
        for (int i = 0; i < 1000; i++)
        {
            dynamic expandy = new ExpandoObject();
            var dictionary = (IDictionary<string, object>)expandy;

            dictionary.Add("ID", i);
            dictionary.Add("Name", "Name" + i);
            rows.Add(dictionary);
        }

So looking at the test code above how would I sort rows (ascending or decending) say on "ID" or "Name" or any other property that I dynamically add?

A bit more info, I'm looking to sort it like this (this doesnt work);

            var newOrder = from r in rows
                     orderby ("Name") ascending 
                     select r;

Why make it dynamic if your always putting a Dictionary in it? — Ash Burlaczenko, Mar 23 '12 at 14:50
Assuming I change it to var rows = new List> how would i sort it? — WooHoo, Mar 23 '12 at 15:08
How do you want it sort? Which value in the Dictionary do you want to use? — Ash Burlaczenko, Mar 23 '12 at 15:22
Sort it ascending or decending. On any property in the dictionary. — WooHoo, Mar 23 '12 at 15:28

score 5 · Answer 1 · edited Jul 10 '15 at 06:53

5

WooHoo's answer does not work for Dynamic.ExpandoObject; this works:

var newOrder = rows.OrderByDescending(x =>((IDictionary<string,object>)x)["Name"]);

edited Jul 10 '15 at 06:53

Cleb

25,102
20
116
151

answered Jul 07 '15 at 08:02

Tholitz_Reloaded

102
2
7

What do you mean by "This does not work for Dynamic.ExpandoObject"? What is "this"; your own answer or do you refer to another answer? – Cleb Jul 07 '15 at 08:06
I was referring to the code var newOrder = rows.OrderByDescending(x => x["Name"]); when used in Dynamic.ExpandoObject. – Tholitz_Reloaded Jul 08 '15 at 07:52
You mean WooHoo's answer from above? – Cleb Jul 08 '15 at 08:07
Yes, I tried it and it wasn't working, for Dynamic.ExpandoObject but for ExpandoObject alone its working. – Tholitz_Reloaded Jul 10 '15 at 04:27

score 5 · Accepted Answer · answered Mar 23 '12 at 15:51

5

Not sure how I missed this but anyway this works,

var newOrder = rows.OrderByDescending(x => x["Name"]);

answered Mar 23 '12 at 15:51

WooHoo

1,912
17
22

How to sort a List containing ExpandoObjects

2 Answers2