How to compare decimal DBNull in Linq?

Question

someDS.someDT.Where(x => x.Amount is not DBNull)
             .Sum(x => x.Amount);

According to the link How to compare DBNull value, the above code should be fine or is there any other way to handle the above scenario?

What is type of `x.Amount`. If it is `DataRow` then use `x.Amount != DBNull.Value` — Fabio, Oct 13 '16 at 04:05

Mostafiz · Answer 1 · 2016-10-13T04:02:38.117

0

If your Amount is a nullable decimal then you can check null value of nullable decimal type as

someDS.someDT.Where(x => x.Amount.HasValue == true)
             .Sum(x => x.Amount);

edited Oct 13 '16 at 04:02

answered Oct 13 '16 at 03:45

Mostafiz

`System.DBNull` does not contain a definition for 'value' – SuicideSheep Oct 13 '16 at 03:50
check updated one – Mostafiz Oct 13 '16 at 03:50
@Mr.SuicideSheep try updated answer – Mostafiz Oct 13 '16 at 03:54
why down vote, please explain it will help to improve answer – Mostafiz Oct 13 '16 at 04:06
It wasn't me, but seems like OP have pointed in comments to you, that your answer not working – Fabio Oct 13 '16 at 04:20
yeah it was previous answer comment after that I have updated answer, and down vote come after that, I think someone have got something they can suggest me to improve – Mostafiz Oct 13 '16 at 04:26

score 0 · Answer 2 · answered Oct 13 '16 at 03:50

0

  someDS.someDT.Where(x => x.Amount != DBNull.Value)
         .Sum(x => x.Amount);

answered Oct 13 '16 at 03:50

this.hart

Operator '!=' cannot be applied to operands of type 'decimal' and 'System.DBNull' – SuicideSheep Oct 13 '16 at 03:52
strange I have posted same answer and op said not working but who upvoted ? – Mostafiz Oct 13 '16 at 03:53

2 Answers2