How do we check multiple columns in where condition using data table LINQ statement

[Gani tpt]

I have the data table. below is the screen shot for reference.



I want to return true, if values "0" (zero) from all the columns (Subject1 to Subject7) in data table and along with one more condition Average should be "0" (zero).

How do we check multiple columns in single LINQ statement in where condition.

For example in the above screenshot,

EM104 ==> satisfied all the conditions. it means all the columns (from "Subject1" to "Subject7") and Average values will be zero. So, it will be return "True"

How do we check multiple columns in single statement..?

Continue reading...