Nullable object must have a value error in linq SQL C#

Question

Getting "Nullable object must have a value" error in LINQ SQL C#

Ramesh Palaniappan · Answer

The problem occurs because you access the Value property of a Nullable type which is null (or, more precisely, whose HasValue property is false). How to fix this depends on what you want to do: If you want to filter out items where TourOpID is null, just add a where clause: (fromb in CompleteData whereb.TourOpID!= null //filter selectb.TourOpID).Distinct() If you want to use a replacement value, e.g. 0, if TourOpID is null, use the null coalescing operator ??, which converts your int? into an int: (fromb in CompleteData selectb.TourOpID??0).Distinct() or, alternatively, select new ComboBoxItemString(){ValueString=a.GetValueOrDefault().ToString()}); If you just want to show a different ComboBox entry if TourOpID is null, use the ternary operator ?:: select new ComboBoxItemString(){ ValueString=(a== null ? "notouroperator" :a.Value.ToString()) }); If you want to show the empty string if a is null, the solution is even simpler: select new ComboBoxItemString(){ValueString=a.ToString()}); since Nullable.ToString returns an empty string if it does not have a value.

Nullable object must have a value error in linq SQL C#

Answers (1)