Using more than one LINQ and receiving SystemNullReferenceException

Asked Apr 27 '17 at 11:26

Active Apr 27 '17 at 12:51

Viewed 30 times

I use more than one LINQ in one function. The first LINQ works well but I have this error "SystemNullReferenceException" for the second LINQ, why?

var data = db.Table<LMLoginTable>();
var data1 = data.Where(x => x.DWFSeen == DW).Where(x => x.MWFSeen == MW).Where(x => x.YWFSeen == YW).FirstOrDefault();
if (data1.RFSeen == 0)
{
....

var data2 = data.Where(x => x.DWSSeen == DW).Where(x => x.MWSSeen == MW).Where(x => x.YWSSeen == YW).FirstOrDefault();
if (data2.RSSeen == 0)
{
.....

edited Apr 27 '17 at 12:51

asked Apr 27 '17 at 11:26

arz

on which line do you get `SystemNullReferenceException`? – Vladyslav Matviienko Apr 27 '17 at 11:30
At first I saw this error on `if (data1.RFSeen == 0)` but after editing LINQ query, I saw this error on `if (data2.RSSeen == 0)`. – arz Apr 27 '17 at 12:53
then obviously data2 is null. `data.Where(x => x.DWSSeen == DW).Where(x => x.MWSSeen == MW).Where(x => x.YWSSeen == YW).FirstOrDefault();` returns null – Vladyslav Matviienko Apr 27 '17 at 12:58

Using more than one LINQ and receiving SystemNullReferenceException

0 Answers0