Suppose we have two lists ( First
and Second
)
Id Value
1 A
2 B
3 C
Id NewValue
1 a10
1 a21
1 a61
2 b71
2 b79
3 c40
3 c48
3 c55
I want to complete a connection request
from p in First
join c in Second on p.Id equals c.Id
select new { p.Value, c.NewValue }
But I also want to impose a condition on the numerical part NewValue
to select the one that is greater than 40. Only a61, then b71, etc. How to change my connection request?
source
share