C# Lambda returns some null values

Question

opencall.Priority = 
averages.Where(x => x.ProblemCode == opencall.ProblemCode)
.SingleOrDefault().Priority;

The above lambda statement returns some nulls because ProblemCode isn't always guaranteed to be in the averages list.

How can I rewrite this statement so that if that is the case opencall.Priority is set to "" instead of the application throwing an error?

Answer 1

Try getting the problem code first, then check if it's null.

var possiblyNullProblemCode= 
    averages.Where(
        x => x.ProblemCode == opencall.ProblemCode)
        .SingleOrDefault();

openCall.Priority = 
    possiblyNullProblemCode == null ? 
        string.Empty : 
        possiblyNullProblemCode.Priority;

Answer 2

You can simply write:

opencall.Priority = 
    averages.Where(x => x.ProblemCode == opencall.ProblemCode)
    .Select(x => x.Priority)
    .SingleOrDefault() ?? string.Empty;

Answer 3

Assuming Priority is string, you could try:

var average = averages.Where(x => x.ProblemCode == opencall.ProblemCode).SingleOrDefault()
opencall.Priority = average == null ? "" : average.Priority;

Answer 4

Split it up:

 var result = averages.Where(x => x.ProblemCode == opencall.ProblemCode).SingleOrDefault()
 opencall.Priority = result != null ? result.Priority : string.Empty;

Answer 5

You have to provide a new default value for your reference type, other than null.

opencall.Priority = averages.Where(x => x.ProblemCode == opencall.ProblemCode)
                            .Select(x => x.Priority)
                            .DefaultIfEmpty("")
                            .Single(); 

So Priority is a string? Note that you don't need SingleOrDefault anymore since the query can never throw an exception because it is empty when you provide a DefaultIfEmpty.