When using LINQ SUM, an exception occurs.

entity-framework linq

Question

I'm trying to get the SUM of "bookings" and I get error "The cast to value type 'Int32' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type."

var bookings = entities.Bookings.Where(x => x.ID == id &&
                                     x.StartDate <= bookingEnd &&
                                     x.EndDate >= bookingStart)
                                    .Sum(x => x.BookingQuantity);

How shall I fix this? I need to get 0 if it ever gets to be null else its bookings.

1
11
11/24/2016 8:22:10 PM

Accepted Answer

Try the null coalescing operator:

var bookings = entities.Bookings.Where(x => x.ID == id &&
                                 x.StartDate <= bookingEnd &&
                                 x.EndDate >= bookingStart && 
                                 x.BookingQuantity != null)
                                .Sum(x => (int?)x.BookingQuantity) ?? 0;

or declare bookings as a nullable int

int? bookings = ...

The compilers type inference is picking up the result of Sum as a plain int, which should never be null.

41
4/15/2011 10:02:07 AM

Popular Answer

This page suggests a fix to this problem;

Sum(x => (int?)x.BookingQuantity) ?? 0;


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow