在进行左连接或右连接时经常出现NULL对象,那么引用NULL对象肯定会报错的,因此在生成对象输出时首先要判断对象是否为NULL,然后再获取NULL对象的属性,可能一部分人会判断对象的属性是否为NULL,对象本身都是NULL,那么肯定不存在属性,引用一个不存在的对象的属性肯定是不可以的,所有要判断对象是否为NULL。
var query = from person in container.T_BASE_PERSON join plan in container.T_PLAN_PLAN on new {PERSON_ID = person.ID, ASSESS_CYCLE = (int?) assessCycle} equals new {plan.PERSON_ID, plan.ASSESS_CYCLE} into temp from personPlan in temp.DefaultIfEmpty() join assessinfo in container.T_BASE_ASSESSINFO on person.ID equals assessinfo.PERSON_ID join org in container.T_BASE_ORG on assessinfo.DEPT_ORG_CODE equals org.ORG_CODE where assessinfo.DIRECTORS_ID.Contains(directorCode) && assessinfo.ASSESS_CYCLE == assessCycle select new { PERSON_CODE = person.PERSON_CODE, PERSON_NAME = person.PERSON_NAME, ORG_NAME = org.ORG_NAME, STATUS = personPlan == null ? -1 : personPlan.STATUS, //左连接,可能为空,下同 ID = person.ID, PLAN_ID = personPlan == null ? 0 : personPlan.ID }; return query.AsQueryable(); }