Ignore the column in lambda when value is null

Question

I am having list of object in which there are null values available in the list. If I want to filter based on few columns in that list using lambda. In this case I have to exclude the filter condition when there is a column comes with null value.

Ex: _db.test.select(x=>x.value1==a && value2==b).tolist();

In this example let's assume value1 has null value. At that time I don't want to use value1 for the condition. I have to eliminate value1 condition. I can go with rest of the conditions available in the lambda expression.

You mean like `((x.value1 == null || x.value1 == a) && value2 == b)`? — ProgrammingLlama, Dec 13 '21 at 06:27
By the way, `.Select` isn't a filter, it's a projection. The result of your code would be a `List`. — ProgrammingLlama, Dec 13 '21 at 06:31

score 1 · Answer 1 · answered Dec 13 '21 at 07:00

1

enumerable.Where( x => ( x.value1 == null || x.value1 == a ) && x.value2 == b )

or

enumerable
.Where( x => x.value1 == null || x.value1 == a )
.Where( x => x.value2 == b )

answered Dec 13 '21 at 07:00

ikegami

367,544
15
269
518

score 0 · Answer 2 · answered Dec 13 '21 at 06:31

0

Inside Select() you can't set condition you must use Where(); Ex: _db.test.Where(x=>x.value1==a && value2==b).tolist();

answered Dec 13 '21 at 06:31

Ehsan.Soltani

62
4

Ignore the column in lambda when value is null

2 Answers2