Check for null entities in EF statement

user_1144596 0
Viewed 69

I have a statement like this:

AssignedCas AssignedCase in caseList.GroupBy(o => o.CaseBatch.CaseBatchName)
                                    .Select(g => g.First()).ToList()

But at time o.CaseBatch.CaseBatchName can be null, in which case the above statement will not execute.

Is there a way in the above statement to check if CaseBatchName is not null and only then include it.

entity-framework-6 c#
1 Answers

You should probably just add a where condition in your Linq. Just like this:

AssignedCas AssignedCase in caseList.Where(o => o.CaseBatch.CaseBatchName != null)
                                    .GroupBy(o => o.CaseBatch.CaseBatchName)
                                    .Select(g => g.First()).ToList()
user_121773050
Related