Ignore Null and Empty string match in Linq Query

Question

How to ignore NULL and empty string match while performing the below query?

var tMisMatchList = lstExchgMatch.Any(o =>
    o.MulDivFlg != lstExchgMatch[0].MulDivFlg);

For example, the list has below data

  [0] = MulDivFlg = "";     // 1st element in the list whose multdivflag value is ""
  [1] = MulDivFlg = null; // 2nd element in the list whose multdivflag value is null
  [2] = MulDivFlg = null; 
  [3] = MulDivFlg = "";

In this case, my above query is returning true. since "" and NULL mismatch has occurred. But my expectation is to ignore null and "" comparison check. It would perform not nullable and non empty string match only. It should ignore the presence of null and "" and treat both as equal

The above query is returning false as it is considering null is not equal to "". But I want it to return true and consider null and "" as equal or ignore wheneever the string is null or "".

Please add what is the result now and what result you expect to receive — Samvel Petrosov
– Samvel Petrosov, Commented May 10, 2017 at 7:05

Ian · Accepted Answer · 2017-05-10 07:25:05Z

3

You could add && (string.IsNullOrEmpty(o.MulDivFlg) != string.IsNullOrEmpty(lstExchgMatch[0].MulDivFlg)) condition in your Any lambda expression:

var tMisMatchList = lstExchgMatch.Any(o => o.MulDivFlg != lstExchgMatch[0].MulDivFlg &&
    (string.IsNullOrEmpty(o.MulDivFlg) != string.IsNullOrEmpty(lstExchgMatch[0].MulDivFlg)));

edited May 10, 2017 at 7:25

answered May 10, 2017 at 7:19

Ian

30.9k20 gold badges76 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Ignore Null and Empty string match in Linq Query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related