"Object reference not set to an instance of an object" LINQ join error

Rohan Ramani

5y3.6kLINQ

Hi All,

I am joining the tables using LINQ. I am getting the error while running "Object reference not set to an instance of an object" . Don't know where I am missing.

var leadlist = from lead in _context.CallDetail.Include(z => z.OutCome).Where(x => x.IsDeleted != true).ToList() join appoint in _context.AppointmentDetail on lead.CallId equals appoint.CallId into ledapp
from appoint in ledapp.DefaultIfEmpty() join allocateto in _context.UserMaster on appoint.RelationshipManagerId equals allocateto.UserId into ledAllocateTo
from allocateto in ledAllocateTo.DefaultIfEmpty()

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya5y ago
Accepted answer
You are joining tables with left outer join. So, There are some null records in appoint. and you join appoint.RelationshipManagerId with allocateto.UserId. So, It will gives you error.
Solution: initialize new ()
var leadlist = from lead in _context.CallDetail.Include(z => z.OutCome).Where(x => x.IsDeleted != true).ToList()
               join appoint in _context.AppointmentDetail on lead.CallId equals appoint.CallId into ledapp
               from appoint in ledapp.DefaultIfEmpty(new AppointmentDetail())
               join allocateto in _context.UserMaster on appoint.RelationshipManagerId equals allocateto.UserId into ledAllocateTo
               from allocateto in ledAllocateTo.DefaultIfEmpty(new UserMaster())
Rajanikant Hawaldar5y ago
make sure ledapp and ledAllocateTo not null when function DefaultIfEmpty() calls its will be error if those are null