C# – The null value cannot be assigned to a member with type decimal which is a non-nullable value type

cexceptionlinq-to-sqlnet

An exception occurs when the following IQueryable is enumerated:

from record in dataContext.SomeTable
select Convert.ToDecimal(record.nullableDecimalColumn);

The error is an InvalidOperationException:

The null value cannot be assigned to a member with type decimal which is a non-nullable value type

The documentation for Convert.ToDecimal says that it converts null to 0, so it looks like it should work correctly.

Best Answer

If you wrote Query like this

tot_vat_amt = _pd.Where(x => x.VAT == 4m).Sum(x =>x.amount)

Replace with

tot_vat_amt = _pd.Where(x => x.VAT == 4m).Sum(x =>(double?)x.amount)

Hope this will help you

Related Solutions

C# – Nullable type as a generic parameter possible

Change the return type to Nullable<T>, and call the method with the non nullable parameter

static void Main(string[] args)
{
    int? i = GetValueOrNull<int>(null, string.Empty);
}


public static Nullable<T> GetValueOrNull<T>(DbDataRecord reader, string columnName) where T : struct
{
    object columnValue = reader[columnName];

    if (!(columnValue is DBNull))
        return (T)columnValue;

    return null;
}

C# – the difference between Nullable.HasValue or Nullable != null

The compiler replaces null comparisons with a call to HasValue, so there is no real difference. Just do whichever is more readable/makes more sense to you and your colleagues.

Best Answer

Related Solutions

C# – Nullable type as a generic parameter possible

C# – the difference between Nullable.HasValue or Nullable != null

Related Topic