C#LINQ Lambda -to get data comparing fields from two lists

J Antoni

9y1.2kLINQ

I have 2 Lists

ListOne ==> ID , Name, Value
ListTwo ==> ID, Desc, Value

Expected Values of ListOne

[1,A,200]
[1,A,300]
[1,A,520]
[2,B,300]
[2,B,350]
[2,B,400]
[3,C,40]
[3,C,20]

Values of ListTwo-Master Data

[1,Analog,500]
[2,Benefit,310]
[3,Chain,50]

My Requirement

I want to get a list(say ResultantList ) that will contain only the value that do not exceed the value of its corresponding ID in the ListTwo.

So the ResultantList is expected to have only the below data from ListOne

[1,A,520] ===> the value here is 520, 520 exceeds the value(500) of ID 1 in ListTwo
[2,B,350] ===> the value here is 350, 350 exceeds the value(310) of ID 2 in ListTwo
[2,B,400] ===> the value here is 400, 400 exceeds the value(310) of ID 2 in ListTwo

===>[...]There is no value from ID 3 (name as C) in ListOne ;as both values(40,20) having ID 3 (name C) in ListOne is less than the value 50 with ID 3 (Desc Chain) in ListTwo

What I have tried

ResultantList = ListOne.Where(s => ListTwo.Any(l => (l.ID == s.ID && s.Value> l.Value))) .ToList();

But this fetches all the values even if the value is less than its corresponding value (w.r.t ID) in ListTwo.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

J Antoni9y ago
This works fine
ResultantList = ListOne.Where(s => ListTwo.Any(l => (l.ID == s.ID && s.Value> l.Value))) .ToList();
I had missed an assignment it between, that's why I was not seeing the expected output.

Thanks Jaspal
JASPAL9y ago
Hi J Antoni,

Your query is working as expected, it's fine.

List lstone = new List(){
new listone{id=1,name="A",value=200},
new listone{id=1,name="A",value=300},
new listone{id=1,name="A",value=520},
new listone{id=2,name="B",value=300},
new listone{id=2,name="B",value=350},
new listone{id=2,name="B",value=400},
new listone{id=3,name="C",value=40},
new listone{id=3,name="C",value=20}
};
List lsttwo = new List(){
new listtwo{id=1,desc="Analog",value=500},
new listtwo{id=2,desc="Benefit",value=310},
new listtwo{id=3,desc="Chain",value=50}
};
var ResultantList = lstone.Where(s => lsttwo.Any(l => (l.id == s.id && s.value > l.value))).ToList();
// OR
var res = (from d in lstone
join d1 in lsttwo on d.id equals d1.id
where d1.value < d.value && d.id == d1.id
select new
{
d.id,
d.name,
d.value
}
).ToList();