Select rows with LINQ from List>

Question

Lets assume simple data:

Dictionary<string, object> dict = new Dictionary<string, object>();
dict.Add("obj 1", null);
dict.Add("obj 2", new object());
dict.Add("obj 3", new object());
dict.Add("obj 4", null);

Dictionary<string, object> dict2 = new Dictionary<string, object>();
dict2.Add("obj 1", null);
dict2.Add("obj 2", new object());
dict2.Add("obj 3", null);
dict2.Add("obj 4", null);

Dictionary<string, object> dict3 = new Dictionary<string, object>();
dict3.Add("obj 1", null);
dict3.Add("obj 2", null);
dict3.Add("obj 3", new object());
dict3.Add("obj 4", null);

List<Dictionary<string, object>> list = new List<Dictionary<string, object>> {dict, dict2, dict3};

Is it possible select rows and remove key/value where in all columns are null? So after this in my list will be:

dict({"obj 2", object}, {"obj 3", object})
dict2({"obj 2", object}, {"obj 3", null})
dict2({"obj 2", null}, {"obj 3", object})

http://stackoverflow.com/questions/1636885/remove-item-in-dictionary-based-on-value — andy, Feb 12 '15 at 07:16

score 1 · Accepted Answer · answered Feb 12 '15 at 07:19

1

try this:

 list.ForEach(x =>
        {

            x.Where(y => y.Value == null).ToList().ForEach(z=>
                {
                    if(list.All(l=>!l.ContainsKey(z.Key)|| l[z.Key]==null))
                        x.Remove(z.Key);
                });
        });

answered Feb 12 '15 at 07:19

st mnmn

3,555
3
25
32

I would like to but I need 2 more reputation .. when I reach it I will do it – Smitis Feb 12 '15 at 09:03

Select rows with LINQ from List>

1 Answers1