CODEWITHSUNDEEP
c#.netlinqlinq-to-entities
ProfK
ProfK

Reputation: 51094

NullReferenceException on trying to enumerate an empty IQueryable

I am getting a NullReferenceException when I try and convert the following LINQ to EF query. What could be wrong here?

            List<DailyProductionRecord> prodRecs = new List<DailyProductionRecord>();
            var recs = from p in productionEntities.DailyProductionRecordSet
                       where ((p.Department.DeptId == dept.DeptId) && (p.RecordDate >= thisPeriodStart) && (p.RecordDate < nextPeriodStart))
                       select p;
            prodRecs = recs.ToList();

EDIT: I've just discovered I was too quick off the mark, and my dept criterion was null.

Upvotes: 0

Views: 1476

Answers (2)

Ronald
Ronald

Reputation: 1815

Aside from accessing properties on objects that can be null (p.Department and dept can both be null), you are also instantiating a new List<DailyProductionRecord> that never gets used. So your example can be written like this:

List<DailyProductionRecord> prodRecs = (from p in productionEntities.DailyProductionRecordSet
                                        where ((p.Department.DeptId == dept.DeptId) && (p.RecordDate >= thisPeriodStart) && (p.RecordDate < nextPeriodStart))
                                        select p).ToList();

Upvotes: 0

uvw
uvw

Reputation: 91

Is p.Department can be null?

Upvotes: 3

Related Questions