CODEWITHSUNDEEP
c#asp.net-mvclinqdictionary
shahbaz usmani
shahbaz usmani

Reputation: 19

Extract record from dictionary list where key and value does not contains given value list c#

List<Dictionary<string, string>> firstList = new List<Dictionary<string, string>>();   
Dictionary<string, string> dict = new Dictionary<string,string>();
dict.Add("name", "abc");
dict.Add("age", "22");
dict.Add("address", "xyz,aa");
dict.Add("contact", "111");
firstList .Add(dict);
Dictionary<string, string> dict2 = new Dictionary<string,string>();
dict2 .Add("name", "pqr");
dict2 .Add("age", "25");
dict2 .Add("address", "xxx,bb");
dict2 .Add("contact", "4222");
firstList .Add(dict2);
Dictionary<string, string> dict3 = new Dictionary<string,string>();
dict3 .Add("name", "aa");
dict3 .Add("age", "24");
dict3 .Add("address", "xxx,aa");
dict3 .Add("contact", "aaa");
firstList .Add(dict3);

return record where list doesn't not contains key = 'address' and name= 'aa'

Update :- return record where name= 'aa'

Upvotes: 0

Views: 1297

Answers (1)

Ehsan Sajjad
Ehsan Sajjad

Reputation: 62488

Pretty simple with linq:

var result = firstList.Where(x => !(x.ContainsKey("address") 
                                && x.ContainsKey(name)
                                && x["name"] == "aa")).ToList();

and if only one record is required back then use FirstOrDefault():

var result = firstList.Where(x => !(x.ContainsKey("address") 
                                && x.ContainsKey(name)
                                && x["name"] == "aa")).FirstOrDefault();

Don't forget to add on top:

using System.Linq;

UDPATE:

var result = firstList.Where(x => 
                                && x.ContainsKey(name)
                                && x["name"] != "aa")).FirstOrDefault();

Upvotes: 1

Related Questions