Nullable type linq c#

Question

in my database there is some row which is null and how can i use nullable type or how can i skip nullable row in linq? but i prefer to use nullable type rather than skip rows (see image)

Possible duplicate of [Linq to DataTable - Cannot cast DBNull](https://stackoverflow.com/questions/7091379/linq-to-datatable-cannot-cast-dbnull) — Tvde1, Feb 13 '19 at 15:53

score 1 · Accepted Answer · answered Feb 13 '19 at 15:36

You can't cast null to a non nullable type (decimal)

You should update your generic type to a nullable type like the below:

From

 let floatingPNL1 = b.Field<decimal>("FloatingPNL")

To

 let floatingPNL1 = b.Field<decimal?>("FloatingPNL")

Another option would be to use an ORM such as dapper, much easier to use and handles the object mapping for you.

score 0 · Answer 2 · answered Feb 13 '19 at 15:34

0

Decimal? should be a nullable type

answered Feb 13 '19 at 15:34

Billy8988

29
1
4

score 0 · Answer 3 · answered Feb 13 '19 at 15:41

0

Use Nullable<decimal> instead of decimal. Read more here

answered Feb 13 '19 at 15:41

PWND

409
3
11

Nullable type linq c#

3 Answers3